Regular expression for removing text

[Printf7]

Dear all,

I would like to remove the unnecessary letter and change the type from Text to Number.

Could you please let me how to do it?
(TEXT) 1,709(0.45%) → (Number) 1709

thanks,
Best regards,

[Yoichi]

Hi,

Can you try the following?

Int32.Parse(System.Text.RegularExpressions.Regex.Match(yourString,"^[\d,]+").Value.Replace(",",""))

Regards,

[NIVED_NAMBIAR (NIVED N)]

Hi @Printf7

You can make the changes to all the rows of datatable at once by using below code in invoke code activity

 dt1.AsEnumerable().ToList().ForEach(Sub(row) row("Pageviews")=System.Text.RegularExpressions.Regex.Replace(row("Pageviews").ToString,"\(.*\)|,",""))

Regards,

Nived N

Happy Automation

[Printf7]

Hello,

It works well! Thank you so much!!