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
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

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'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?