reading quoted strings with comma in a csv file

Hi,

What is the best way to handle common in a CSV file .

For example I have a Comma separated value like the following .

123,'where are, you going',345,city

I was not able to read the above properly , because matlab was considering the comma after """where are, """ as a separator .But this comma is actually a part of value .

Could you please let me know how to handle this with regular expression ?

regards Mahesh

Answer 1

[Dahai Xue]

On a PC with Excel installed, it is easy to use this statement

[~, ~, myTable] = xlsread('myFile.csv').

It handles quotes nicely. The 1st output is for numeric data only, and 2nd for strings only, while the 3rd for both in cells. The 3rd output must be used to keep the headers in the table.

[Al in St. Louis]

Thank you. I can't believe that readtable still can't parse this correctly.

Answer 2

[per isakson]

Try textscan in combination with

    '%q'

String, where double quotation marks indicate text to keep together

Single quotation mark might not be supported.

See the answer on comma and point decimal separator. You might be able to use that method to replace single quotes by double quotes.

[Mahesh]

Thanks