I have json object that includes the below:
{
"x":"avc123.abc.com",
"z":"24 - ny"
}
and I would like to only target "x" value for "123" (numbers only) and the rest won't get picked up such as "z"
so the expected output would be {
"x":"avc123.abc.com",
"z":"24 - ny",
"y":"123"
}
please note that the "z" value of "24" is not being picked up. "y" value is only being picked up from x value.
I already done the below
Add new property in ExtractText processor
val
(\d+)
-
Then use ReplaceText processor with below configs:
Search Value