How to get the string without the ","

Dear all,

Good day.

i have a text which is 1,000.00, but i want to get the results of 1000.

How can i do that? kindly advise.

Thank you.

Hi,

Can you try the following?

Let’s say yourString="1,000.00"

Double.Parse(yourString,System.Globalization.NumberStyles.Any).ToString

Regards,

Hi there,

Try the following expression to remove the comma:

Use Assign activity → yourStringName.Replace(",","")

Now, to remove the dot (.), try the this expression:

Use Assign activity → yourStringName.Replace(".","")

When assigning both to the same String that you want it to be removed/replaced, you will get the expected output. Don’t forget to assign it before outputting the result, otherwise it won’t work,

Peace.

Dear all,

Thanks for your reply.

I am able to get the string without “,”.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.