textscan - import the k-th out of n columns and ingore the 1st row which contains column names

1 view (last 30 days)
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.

Accepted Answer

Walter Roberson
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);

More Answers (0)


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!