CSV Delimiter while Quote

[Anonymous]

Hello Team,

I am trying to split the csv file with the | demiliter and the delimiter is also available in the " " which i do not want to split. 

As usual i have used Quote character but it is not taking the quote character and splitting the data between the  X|" test1| test2| test 3"| Y which ideally should split into   X  test1|test2|test3 Y but it is splitting into X test1 test2 test3 Y.

When we take small dataset it is not happening. It is happening on the medium size files like 20+ Mb. 

Please provide an update.

Regards,

Ibrahim

[Anonymous]

Hi @Anonymous ,

Power BI should ideally handle CSV files correctly, respecting the quote characters and not splitting data within quotes even when the delimiter is present.

When loading the CSV file into Power BI, ensure that you’ve set the correct delimiter (|) and quote character (").

If the file size is causing the issue, try splitting the file into smaller chunks and then load them into Power BI.

As mentioned earlier, you could preprocess the data to temporarily replace the | characters within quotes with a unique character sequence that is not present elsewhere in the data. After loading the data into Power BI, you can replace this unique character sequence back to |.

Best regards.
Community Support Team_Caitlyn