Forum Discussion

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

 

 

Edit: comma is the separator for the csv file.

 

Need Help

3 Replies

  • Pragati11's avatar
    Pragati11
    Super 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
      Post 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?