Output CSV file with commas as decimals

[pericoduran]

Hello, I have a full workflow done and just need to download the output into a folder using the Output tool. I work with dots as decimals but my client needs a file with commas as decimals. I am trying to download the CSV file so that it has commas as decimals but I am unable to do so. Can you please tell me what settings do I need to modify to be able to extract the output in the desired way?

[Jonathan-Sherman · Accepted solution]

Hi @pericoduran,

You'd have to store the value as a string and replace the decimal with a comma.

Replace(ToString([Values]), '.', ',')

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[pericoduran]

Thanks! Now it works! 

[DavidP]

Jonathan's method is spot on.

There is also an option in the Tostring() function to specify what you want to use as the decimal separator. Go one step further and use the Multi-Field formula tool where you can change both the value and datatype of a field in a single step.