Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.