textscan - import the k-th out of n columns and ingore the 1st row which contains column names
1 view (last 30 days)
Show older comments
Nikolaos Gkiouzelis
on 20 Sep 2022
Answered: Walter Roberson
on 20 Sep 2022
My txt file contains more than 100 columns and rows. How can I save any column avoiding the following
Mydata = textscan(fid,'%f %f %f %f %f ... %f','HeaderLines',1); % %f as many as the number of columns
If any line/function is more efficient for my case please recommend it.
Thank you in advance.
0 Comments
Accepted Answer
Walter Roberson
on 20 Sep 2022
cols_to_keep = [17, 83:85]; %for example
fmt = repmat({'%*f'}, 1, NumberOfColumns); %read but do not sae
fmt(cols_to_keep) = {'%f'}; %read and save
fmt = [fmt{:}];
MyData = textscan(fid, fmt, 'HeaderLines', 1);
0 Comments
More Answers (0)
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!