Hi All,
I am bringing in data from database that reads my numeric data as text
Before conversion/Raw data: 50.456.492,96 and Text Data type (V_W String or String)
I tried using the select tool to convert back to numeric using Double but it outputs
After conversion using Select Tool: 50.456 and Numeric Data type (Double)
Also I tried using Regex_Replace but I guess I'm missing an input.
Intended Output: 50.456.492,96 and a Numeric Data type (Double)
Thank you all for your help.
Solved! Go to Solution.
Hey,
using a formula to replace the comma and dot like this: replace(replace([Field1],'.',''),',','.') makes the string easily convertible to double.
Then you can change in your user settings (options -> user settings -> localization) how you want decimal and thousand separators displayed.
See workflow attached.
Hey KilianL,
Thanks a lot for your help. That works.
Though I went to (options -> user settings -> localization) but unable to see where to modify decimal and thousand separators.
Thank you.
Hey @inumidun2009,
great to hear it works now!
It is actually a new option for Version 20.4, so you will need to update your Software for it.
It looks like this:
All the Best
Kilian Leifeld
Sales Engineer, Alteryx
Thanks a lot, Kilian.
Kind regards.
Taiwo Adegoke.
Thank you very much. It helped me a lot with a flow. You're awesome. 😁