Read csv with quotes and numbers
2 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
Chunru
on 14 Sep 2022
type data.txt
fid=fopen("data.txt", "r")
a=fscanf(fid, '%d,"%d,%d,%c"', [4 inf])'
fclose(fid)
0 Comments
More Answers (0)
See Also
Categories
Find more on Data Import and Analysis in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!