Loading ascii data file with headers
14 次查看(过去 30 天)
显示 更早的评论
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 0.000000000E+00 1.647949222E-09
1 3.100000000E-07 1.665649396E-09
2 6.200000000E-07 1.679992701E-09
3 9.300000000E-07 1.701660146E-09
4 1.240000000E-06 1.721191412E-09
5 1.550000000E-06 1.745300238E-09
6 1.860000000E-06 1.777038627E-09
7 2.170000000E-06 1.811218286E-09
8 2.480000000E-06 1.844787545E-09
9 2.790000000E-06 1.878662115E-09
10 3.100000000E-06 1.914672865E-09
11 3.410000000E-06 1.954650886E-09
12 3.720000000E-06 1.990966725E-09
I would like to have just a matrix with the numerical values. Any ideas?
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 ?
采纳的回答
Matt Kindig
2013-4-25
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 个评论
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');
更多回答(2 个)
Cedric
2013-4-25
编辑:Cedric
2013-4-25
The following would be an option:
[index, distance, tip_A] = textread('myFile.txt', '%d %f %f', 'headerlines', 3) ;
3 个评论
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.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!