Loading ascii data file with headers

Question

David Polcari 2013-4-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/73574-loading-ascii-data-file-with-headers

评论： Maryam Huck 2021-5-1

采纳的回答： Matt Kindig

在 MATLAB Online 中打开

Hi,

I am having trouble loading a data file into matlab with some headers. Here is an sample of what I have:

Series_6_2
Sweep_6_2_1    4.924117200E+04   13:40:41.171
"Index"   "Distance[m]"      "I-tip[A]"      
  0.000000000E+00    1.647949222E-09
  3.100000000E-07    1.665649396E-09
  6.200000000E-07    1.679992701E-09
  9.300000000E-07    1.701660146E-09
  1.240000000E-06    1.721191412E-09
  1.550000000E-06    1.745300238E-09
  1.860000000E-06    1.777038627E-09
  2.170000000E-06    1.811218286E-09
  2.480000000E-06    1.844787545E-09
  2.790000000E-06    1.878662115E-09
  3.100000000E-06    1.914672865E-09
  3.410000000E-06    1.954650886E-09
  3.720000000E-06    1.990966725E-09

I would like to have just a matrix with the numerical values. Any ideas?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Maryam Huck 2021-5-1

Hi, How to open the data, when the structure given above, repeats several time? i.e.:

Header = Parameters

Data

Header = Parameters

Data

Header = Parameters

Data

Header = Parameters

Data

How to then extract all the data, each in different rows ?

请先登录，再进行评论。

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

Answer 1

Matt Kindig 2013-4-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/73574-loading-ascii-data-file-with-headers#answer_83490

在 MATLAB Online 中打开

This should do it

fid = fopen('path/to/your/file.txt', 'rt');
Data = textscan(fid, '%d %f %f', 'headerLines', 3, 'CollectOutput', true);
fclose(fid);
Data= cell2mat( Data);

2 个评论
显示无隐藏无

David Polcari 2013-4-25

Quick follow up: I am trying to use inputdlg to prompt the user to enter the filename:

filename = input('Enter filename with extension: ','s');

I want to use filename in the rest of your lines but can't seem to get it to work. Any ideas?

Iain 2014-2-3

uigetfile would be better than filename. Just remember to concatenate the path & filename it returns into "filename", then,

fid = fopen(filename,'rt');

请先登录，再进行评论。

Answer 2

Cedric 2013-4-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/73574-loading-ascii-data-file-with-headers#answer_83489

编辑：Cedric 2013-4-25

在 MATLAB Online 中打开

The following would be an option:

 [index, distance, tip_A] = textread('myFile.txt', '%d %f %f', 'headerlines', 3) ;

3 个评论
显示 1更早的评论隐藏 1更早的评论

Matt Kindig 2013-4-25

The textscan() function (that I've used below) will automatically stop once the pattern is no longer found, which means that it should ignore the text at the bottom of the file. I'm not sure about textread() though.