Regex Extraction Digits

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Hi,

I have this string: You’ve viewed 72 of 2,167 products

I want to extract the “2,167” digits without the comma.

Can someone guide me how to do that please?

thanks!

[Yoichi]

Hi,

Is there any rule to extract it, such as “before ‘products’ etc”?

Regards,

[Gokul001 (Gokul Balaji)]

Hi @Yudhisteer_Chintaram1

Here is the sample workflow
securestring.xaml (6.0 KB)
Try this and let me know

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Yes the numbers is always going to be before “products”.

[ppr (Peter Preuss)]

used for extreaction
aftwrwards we can remove the comma e.g. by using Replace(“,”,“”)

[Gokul001 (Gokul Balaji)]

Hi @Yudhisteer_Chintaram1

securestring.xaml (6.0 KB)

I think this will work based on your suggestion.

If it is working, then mark as solved

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Thanks!