Extracting Data from file with varying columns

Question

Ravindra 2018-5-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/401899-extracting-data-from-file-with-varying-columns

评论： Ameer Hamza 2018-5-22

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 个评论
显示 1更早的评论隐藏 1更早的评论

jonas 2018-5-22

did you try dlmread?

Ravindra 2018-5-22

Data.txt

small part of the data is following

请先登录，再进行评论。

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

Answer 1

Ameer Hamza 2018-5-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/401899-extracting-data-from-file-with-varying-columns#answer_321337

编辑：Ameer Hamza 2018-5-22

在 MATLAB Online 中打开

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{:})