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.
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.
Proud to be a Super User!
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?
Check this link: https://blog.crossjoin.co.uk/2015/05/25/working-with-international-date-and-number-formats-in-power-...
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.