Extract every 10th value from the excel file and save into new file

5 views (last 30 days)
Hi,
Attached file have 2 columns and 7177 rows. I want every 10th rows from both column extracted and in the end save into different csv file for example: 10th 20th 30th 40th so on, can anyone help. I am not sure how to do it.

Accepted Answer

David Hill
David Hill on 23 Mar 2021
a=readmatrix('Book1.csv');
b=a(10:10:end,:);
writematrix(b,'Book2.csv');

More Answers (1)

Cris LaPierre
Cris LaPierre on 23 Mar 2021
Use indexing (Ch 5 MATLAB Onramp).
You'll probably need to load the file into MATLAB (use readtable or readmatrix), copy every 10th row to a new table, then write that table to a new file using writetable or writematrix.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!