Change Coding between US and EU csv

[joshua1990]

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 get this done without marking the specific columns and to chance '.' by ',' ?

Edit: comma is the separator for the csv file.

[Pragati11]

Hi @joshua1990 ,

Your problem is not clear to me. Can you explain more please? If you want to chnage something in your file, you can chnage it independently.

Thanks,

Pragati

[joshua1990]

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?

[camargos88]

Hi @joshua1990 ,

Check this link: https://blog.crossjoin.co.uk/2015/05/25/working-with-international-date-and-number-formats-in-power-...