Hi - what is the best way to convert these from string to numbers. I have tried and it keeps returning just the numbers before the comma. I can't remove all punctuation because I also want to keep the decimal place. thanks!
4,006,213,560.39
19,905 386,716.32
108,471
2,108,988.82
72,053,698.07
1,453,328.96
2,364,943.17
Solved! Go to Solution.
Thanks, that worked. I also have numbers that are like this:
874.19-
How would I make that into a negative number? I am thinking an if formula, but not sure how to tell Alteryx to add - to the beginning of the number and remove it from the end.
Good and easy solution. Thank you.
Is there any way to use this in a data cleansing tool? In my case there are about 200 numbers coming in from Excel with commas and decimals being interpreted as strings. Doing a replace 200 times and creating a manual cleansed version of every field is going to be incredibly tedious. I see that you can remove punctuation but that seems to remove the decimal with the comma. The problem is that when I convert these to Float with the Select tool, it stops reading after the comma.
A Multi-Field Formula would be your next step.
A very simple way to do this is to place a formula tool and write the function tonumber([column_name]) and then place a select tool immediately after and select one of the numeric data types like double or fixed decimal for that column.