reading quoted strings with comma in a csv file

Question

Mahesh 2014-2-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/114727-reading-quoted-strings-with-comma-in-a-csv-file

评论： Al in St. Louis 2022-5-20

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Dahai Xue 2015-1-28

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/114727-reading-quoted-strings-with-comma-in-a-csv-file#answer_166152

编辑：Dahai Xue 2015-1-28

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.