Unable to determine formatSpec while reading .txt file by fscanf
4 views (last 30 days)
Show older comments
Hi, i'm trying to make [n , 4] table with the a.txt
I need only need numeric datas but i have no idea which formatSpec i need to use.
I have no idea how to deal with the space blanks between numbers i need.
a = fopen('a.txt' ,'r')
data = fscanf(a , FromatSpec , [4 inf])
Please let me know which formatSpec i need to use.
1 Comment
Walter Roberson
on 4 Nov 2020
textscan with headerlines set to about 9 or 10 (not sure from my phone)
Accepted Answer
Ameer Hamza
on 4 Nov 2020
This is one way:
lines = strsplit(fileread('a.txt'), '\n', 'CollapseDelimiters', false);
idx = find(contains(lines, 'Global Statistics'));
idx = [9 idx+10];
data = cell(1, numel(idx));
fid = fopen('a.txt' ,'r');
line_read = 0;
for i = 1:numel(idx)
data{i} = textscan(fid , '%f %f %f %f', 'HeaderLines', idx(i)-line_read);
line_read = idx(i) + numel(data{i}{1})+1;
end
fclose(fid);
[data, idx] = cellfun(@(x) deal({[x{:}]}, isempty(x{1})), data);
data(idx) = [];
0 Comments
More Answers (0)
See Also
Categories
Find more on Large Files and Big Data in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!