Hi Experts,
Mapping requirement is to pick the numeric part from input & populate it in the target field.
Say if in input we get value like 'Box 23' then output value should be '23'.
Eg:
Box 23 [Input] - 23 [Output]
Postfach 1261 [Input] - 1261 [Output]
Thanks,
Ramu.
Hi Ramu,
try this in your UDF:
return var1.matches(“.*[0-9]{10}.*”);
or use this blog
The power of regular expressions in graphical mapping (XI)
Regards,
Alex
Hi Ramu,
You can use regex and delete non-digits.
str = str.replaceAll("\\D+","");
Hi Xinjiang,Alexander,
Thank you for your reply.
My input queue and output queue of UDF should look like below:
Input queue:
Output queue:
Can you help with UDF.
Thanks,
Ramu.