convert text to numeric- But retain comma and decimal

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.

Accepted answers

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,

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.

Thank you very much. It helped me a lot with a flow. You're awesome. 😁