CSV with comma and speech marks as delimiters

[CEllis]

Hi All,

Hopfully someone can help me get started with this.

I am importing multiple csv file from a sharepoint folder and found the delimitors are showing as a comma and speechmarks.

I can get the data to import into a dataflow but it doesnt keep the data in the correct columns when it comes across a comma between a set of speech marks.

Does anyone know how to set the import to use both speech marks and commas as delimitors ?

Sample data

[GilbertQ · Accepted solution]

Hi @CEllis 

What I would recommend doing is chat to the people who are crowded in the csv file to see if they can change the delimiter from a comma dilemma to another value so that you can then import it successfully.