Need to modify the string

[shruthi_arali]

Hi All,

I need to modify the value from (17,039.66) to 1703966
please help to convert the above value to 1703966

[Gokul_Jayakumar (Gokul Jai)]

Hello @shruthi_arali , Try replace method

YourStr=17,039.66

YourStr.Replace(",","").Replace(".","")

If data with bracket

YourStr=(17,039.66)
YourStr.Replace(",","").Replace(".","").Replace("(","").Replace(")","")

Also Try Regex replace method

System.Text.RegularExpressions.Regex.Replace(YourStr,"\W","")

[Praveen_Mudhiraj]

HI @shruthi_arali

str_Variable=System.Text.RegularExpressions.Regex.Replace(“(17,039.66)”,“[(),.]”,“”)

You can try with regex also

[Kartheek_Battu]

Hello @shruthi_arali

1. Take “Assign” activity.
2. In the “To” field of the “Assign” activity, create a variable to store the converted value. Let’s call it “convertedValue” and set its data type to Integer.
3. In the “Value” field of the “Assign” activity,

• OriginalValue As String = “17,039.66”
• ConvertedValue As Integer = Integer.Parse(originalValue.Replace(“,”, “”).Replace(“.”, “”))

Thanks & Cheers!!!