How to convert string to number?? example "-12 789,32"

Question

Hello,

I am exporting the data from SAP and the balance are in this format "-12 389,32" or "-79 456,43" or "42 761,59". It contains spaces a thousands separator and comma for decimal separator. Whenever I choose the type int or double in select the output result would be in  -12 or -79 or 42. choosing float or fixed decimal would result in null. Can someone help in converting it to number.

binu_acs · Answer

@ShravaniChanda I don't think the Alteryx string format (-12 389,32) can be outputted to excel as numeric. you need to pass the amount as numeric then format the excel to reflect according to your requirement

ShravaniChanda · Answer

Hey @binu_acs ,

I appreciate your reply, but i want the output to look exactly same as the input but the datatype to be in numeric. I am updating this data to an excel template, where there are many calculated columns in excel depending on this output column.

Please advice

ShravaniChanda · Answer

Hi @JosephSerpis

Thanks for the prompt response, but the problem here is I want to output the data in the same format to an excel.

for example -  "-12 389,32" is in string first, then after conversation also it should be in the reman same as "-12 389,32" so that when i output that into excel the it will be populated as numeric field.