Loading Text File with Multiple sections of headers
18 views (last 30 days)
Show older comments
Hi All, I am trying to using the "importdata" command to import to Matlab 2012a from a file that has multiple sections of headers. The file looks like:
header header header
1 1 1
1 1 1
header header header
2 2 2
2 2 2
However, import data will only return the data after the first line of headers (in this example a 2x3 matrix of 1's). How can I get it to also read the data after the second set of headers (so a 4x3 matrix for this example of 1's then 2's). Thank you for the help.
Brendan
2 Comments
Walter Roberson
on 8 Jun 2012
Do you know the exact amount of data in each section ahead of time?
Do you want the data broken up into parts, or do you want all the data together?
Does the header always start with the same string?
Accepted Answer
Walter Roberson
on 8 Jun 2012
As you know the amount of data in each section, fopen() the file, and textscan() it section by section, using the 'HeaderLines' option and passing in the count of the number of lines to read.
numlines = 2;
thissectionCell = textscan(fid, '%f%f%f', numlines, 'HeaderLines', 4, 'CollectOutput', 1);
More Answers (1)
per isakson
on 8 Jun 2012
importdata cannot handle your file.
An approach is to
- read the file as characters to a string, buf
- split the string, buf, into one string of characters per block of header&data
- parse each block with textscan
Something like
function M = Answer( )
fid = fopen( 'cssm.txt', 'r' );
buf = fread( fid, '*char' );
sts = fclose( fid );
while buf > 0
ix2 = first position of next header
str = buf( 1 : ix2-1 );
buf( 1 : ix2-1 ) = [];
cac = textscan( str, format );
peel off the braces
end
end
or write the blocks to separate files and read with importdata.
0 Comments
See Also
Categories
Find more on Large Files and Big Data 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!