Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

CSV Delimiter while Quote

Submitted by Anonymous on ‎02-08-2024 10:15 PM

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

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎02-11-2024 05:10 PM

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

Idea Statuses