Hello,
I have strings like this
(* 22,000_)
desired output
22000
I have tried this expression (?<=)[\d]+ but it just returns 22.
Thanks in advance
Hello,
I have strings like this
(* 22,000_)
desired output
22000
I have tried this expression (?<=)[\d]+ but it just returns 22.
Thanks in advance
Check below for your reference as an alternative
Do a Replace as StringVariable.Replace(“,”,“”)
Now use below
system.Text.RegularExpressions.Regex.Match(ColumnData,"\d+")
Hope this may help you
Thanks
you can also replace anything else except numbers with nothing, which will give you a plane number string that can be converted into an integer. Syntax below
System.Text.RegularExpressions.Regex.Replace(“strTextTobBeTreated”,“\D”,“”)
make sure to add the namespace System.RegularExpressions
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.