Read data from text file. Tables with uneven number of rows
3 views (last 30 days)
Show older comments
I have data of following shape.
I need to save all the numerical values in tables from the file as matrices. The problem is that all the tables have different number of rows. What would be the best way to go about solving the problem. Thanks
3 Comments
Benjamin Thompson
on 10 Feb 2022
How do you want the data combined together? If you combine everything into a single table then you will have rows from different trajectories. Is that OK? Can you provide more information about what you want?
Answers (1)
Turlough Hughes
on 11 Feb 2022
Edited: Turlough Hughes
on 11 Feb 2022
fid = fopen('t1.txt');
c = 1;
while ~feof(fid)
d = fgetl(fid);
if ~isempty(regexp(d,'X.*Y.*Z.*Energy', 'once'))
part = textscan(fid,'%f%f%f%f');
data{c} = [part{:}];
c = c+1;
end
end
fclose(fid);
This uses fgetl to find the headers, then textscan reads the arrays.
2 Comments
Stephen23
on 11 Feb 2022
Replace the WHILE and IF with the simpler
while ~feof(fid)
...
end
See Also
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!