Parsing digit from a sentence

[amitsingh88]

Hi,

I want to extract only number from the string, I tried like this but not getting whole number like in first example I want to get 12342 but getting only 12.

 Please suggest the method.

Thanks

Amit

[christine_assaad]

Hi @amitsingh88 

Other than Regex, you can use Data cleansing to get rid of letters and punctuation. Please see below.

[christine_assaad]

If you need to use Regex, you may try the below as well. Hope this helps. Cheers!