Read csv with quotes and numbers

Question

AG15 2022-9-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1805220-read-csv-with-quotes-and-numbers

回答： Chunru 2022-9-14

Hi,

I have a csv file which contains the follwing format. Unfortunatelly it is not possible to remove the douuble quotes due to the method in which the data is generated. I am not able to parse out the data after the double quotes as the import data is treating it as a single field. Ideally I need to parse it as 1,10,10,A but it is not able to identify the delimiter in the double quotes.

data format:

1,"10,10,A"

4,"10,14,A"

15,"10,11,B"

Below is the readout when I try to import the data

What would you recommend? Thanks a lot!

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

请先登录，再进行评论。

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

Answer 1

Chunru 2022-9-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1805220-read-csv-with-quotes-and-numbers#answer_1053360

在 MATLAB Online 中打开

data.txt

type data.txt
1,"10,10,A"
4,"10,14,A"
15,"10,11,B"
fid=fopen("data.txt", "r")
fid = 3
a=fscanf(fid, '%d,"%d,%d,%c"', [4 inf])'
a = 3×4
     1    10    10    65
     4    10    14    65
    15    10    11    66
fclose(fid)
ans = 0