CONVERTING STRING TO NUMBER AND REMOVING COMMA IN THE FIGURES

Question

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:

AmountData Type6,216,000.00V_String1,234V_String-500,000.00V_String

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

AmountData Type6216000.00Double1234Double-500000.00Double

Please help me to solve this one. Thank you!

Emil_Kos · Answer

Hi @dunkindonut7777,

I have preapred a workflow for you:

I used this formula to remove,

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

Hope it helps 🙂

Test.yxmd

JosephSerpis · Answer

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?

Multi_Field_17022020.yxmd

grazitti_sapna · Answer

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.

ConvertDouble-GS.yxmd