Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
6 years ago

Change Coding between US and EU csv

Hello everybody! I am trying to extract the latest csv-file from a folder. Unfortunately, all numbers are based on the US code. I need to replace all dots with a comma. Is there any simple way to...
Need Help
joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
6 years ago

thanks for your help!

I have a csv file that has the following structure

Name,Name,Name,55555.00524, 55.059652,Name, 987654.45698

As you can see there is a comma (",") as separator and the dot (".") for decimal numbers.

So, I am referencing to this file and load it into Power Query and then I have the columns based on the comma separator.

Since we are an EU company we are working with a comma for decimal numbers.

I need to change all numbers by replacing the dot by a comma.

 

Is there any way to do this without replacing values?

Any area coding type or so?