CONVERTING STRING TO NUMBER AND REMOVING COMMA IN THE FIGURES

[dunkindonut7777]

Hi I have a problem converting the figures from string type of data to number format type of data. Because if I only use the select tool and change the data type it will rounded off and caused error. I would like to change the amount figures from string to number type of data. See sample below:

Amount	Data Type
6,216,000.00	V_String
1,234	V_String
-500,000.00	V_String

From the table above I would like to be transformed it into:

Amount	Data Type
6216000.00	Double
1234	Double
-500000.00	Double

Please help me to solve this one. Thank you!

[grazitti_sapna]

Hi @dunkindonut7777 , try this. You can first use formula tool to replace the comma with a blank char. Then use select tool and convert the field into double.

If this helps kindly mark this post as solution.

Thanks.

[JosephSerpis]

Hi @dunkindonut7777 you will need to use a replace function to remove the commas. I mocked up an approach using a multi-field tool which shows how to do this as this is the only tool that can change the data format while applying a formula to a field. Let me know what you think?

[Emil_Kos]

Hi @dunkindonut7777,

I have preapred a workflow for you:

I used this formula to remove,

Replace([Amount], ',', '')

Hope it helps 🙂