Read csv with quotes and numbers
6 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
AG15
el 14 de Sept. de 2022
Respondida: Chunru
el 14 de Sept. de 2022
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
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1124775/image.png)
What would you recommend? Thanks a lot!
0 comentarios
Respuesta aceptada
Chunru
el 14 de Sept. de 2022
type data.txt
fid=fopen("data.txt", "r")
a=fscanf(fid, '%d,"%d,%d,%c"', [4 inf])'
fclose(fid)
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Data Import and Analysis en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!