How to remove intermittent headers from data
Show older comments
I have a large .txt file (77,000 rows) with intermittent headers in the data (see attached picture). I'm trying to get all the numeric data into a mx3 matrix. "importdata" works great until it encounters the first intermittent head, and then it stops.
This is what I have been trying, but like I said, it stop once it reaches the first buried header
filename = 'test1.txt';
[B,delimeterOut,headerlinesOut] = importdata(filename);
Load_Time = B.data(:,1);
Load_Displacement = B.data(:,2);
Load_Force = B.data(:,3);
3 Comments
Stephen23
on 4 Aug 2018
@Jason Shepherd: please upload a representative file by clicking the paperclip button. Note it does not have to have lots of line, but needs to represent the pertinent features of the files.
You might be interested to read this, this concept can be adapted to read files with header rows interspersed among the data:
per isakson
on 5 Aug 2018
Edited: per isakson
on 5 Aug 2018
"(see attached picture)" Nothing attached. You need to both [Choose File] and [Insert Image].
per isakson
on 5 Aug 2018
Answers (0)
Categories
Find more on Text Files in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!