Extracting Data from file with varying columns
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Ravindra
el 22 de Mayo de 2018
Comentada: Ameer Hamza
el 22 de Mayo de 2018
Hi all, Our system is capturing data continuously. Where first 14 columns are always stored in *.txt and *.log file. The 15th column is added only when the image is captured. So the data in file looks like following:
I am asking this question, because I was not successful after trying out importdata, readtable and all possible MATLAB answers. When the pointer comes to the 15th column data. It reads the value for e.g. (here 11) and store it to the next row instead in the same row. Also, the values read after that all are NaN.
It would great, If I am able to load the this data automatically. Using a self written function.
Thank you very much for the help and valuable suggestions in advance.
3 comentarios
Respuesta aceptada
Ameer Hamza
el 22 de Mayo de 2018
Editada: Ameer Hamza
el 22 de Mayo de 2018
Try something like this
f = fopen('data.txt');
data = textscan(f, '%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f', 'Headerlines', 1); %%read 15 columns
fclose(f);
data{end} = [data{end}; nan(length(data{1})-length(data{end}))]; %%make length of last column equal to other columns
result = table(data{:})
result will contain the data in the form of table.
Edit: Edited the answer according to the uploaded data file.
0 comentarios
Más respuestas (1)
Ravindra
el 22 de Mayo de 2018
1 comentario
Ameer Hamza
el 22 de Mayo de 2018
Yes, I noted that after you uploaded the file and modified the answer.
Ver también
Categorías
Más información sobre Data Import and Export en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!