UDF to Strip Non Numeric characters

[Former Member]

Hi experts,

Can anyone help me with an UDF which strips non numeric characters.

Example: 123-456.789

output should be :  123456789

Regards,

Mastan vali

[manoj_khavatkopp · Accepted solution]

hi Mastan,

try these. (take inp as input type string)

String str= null;

str = inp.replaceAll("\\D+","");

return str;

Regards,

Manoj

[diego_gabriel · Accepted solution]

Hi Mastan,

Another regular expression could be

s.replaceAll("[^0-9]", "");

where 's' is your input string.

Regards,

Diego

[Former Member · Accepted solution]

it worked.....Thank you Manoj

[former_member186851]

Hello Mastan,

Try the below code

input.replaceAll("[^0-9]", "");