Read text file efficiently

12 次查看（过去 30 天）
Mjan88
Mjan88 2019-1-24
评论： Walter Roberson 2019-1-27
Hi all,
Does anybody has an idea how to efficiently read a *.txt-file in following format:
1/ 2/2019 01:30 -1.59 0.39 253
1/ 2/2019 01:45 -1.78 0.35 250
1/ 2/2019 02:00 -1.94 0.31 246
1/ 2/2019 02:15 -2.07 0.26 240
I would like to have 8 columns (day, month, year,hour, minute, param1, param2, param3).
The file also has some headers btw.
Like to hear your advise!
  2 个评论
Image Analyst
Image Analyst 2019-1-25
Don't forget to attach your text file again, if you still need help.
There are lots of input options, like importdata(), textscan(), etc. if readtable() doesn't work.

请先登录，再进行评论。

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

回答（2 个）

Walter Roberson
Walter Roberson 2019-1-25
fid = fopen('YourFile.txt', 'rt');
data = cell2mat( textscan(fid, '%f/%f/%f %f:%f %f %f %f', 'collectoutput', true);
fclose(fid);
  3 个评论
显示 1更早的评论
Mjan88
Mjan88 2019-1-27
Thanks, Walter Roberson. This works fine, except that for some kind of reason the first two data-lines are skipped. I don't know what causes this. Do you have an idea?
Walter Roberson
Walter Roberson 2019-1-27
You could try reducing HeaderLines to 4 on the second textscan. But I tested on your supplied file and the output looked fine to me.

请先登录，再进行评论。

Mjan88
Mjan88 2019-1-26
Thanks for the suggestions. Textscan seems to work better indeed, IF I do not have headers. Like Image Analyst already suggested, hereby the textfile itself. Does anybody have an idea how to obtain longitude, latitude, and the data itself (day, month, year,hour, minute, param1, param2, param3)? Thanks!

类别

在 Help Center 和 File Exchange 中查找有关 Text Data Preparation 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by