Combining .csv files but commas are causing errors

[Madra]

Hello everyone,

New to Power Query and this forum too, i couldn't find an answer anywhere else so i'm asking it here (sorry if it has already been answered somewhere) (also, i should mention that it is Power Query in Excel 2016, i don't know if it is different from Power Query in Power BI).

I have multiples automatically generated .csv files in a folder, looking like this (notice that this isn't a table) :

I'm trying to combine them using Power Query so here is what i get at the beginning:

 and after combining the binaries, here is what i have, and there is my problem, the comma is causing an error:

If i remove the errors, here is the result i'm expecting, but i obviously don't want to remove the errors as i need those rows.

I tried to replace the comma character in the binary but couldn't find a way to do it.

Anyone has an idea to help me ?

Thanks in advance,
Madra

[Madra · Accepted solution]

Hello, found my solution.

For anyone interested by it, i went into the advanced editor and changed the automatically generated function from Csv.Document(#"Combined binaries", null, null, 1252) to Csv.Document(#"Combined binaries",[Delimiter=";",Encoding=1252])