- dir() -- command to get a listing of the files and directories
- M = csvread(...) -- read in each file identified in the first step
- M(1:3,:) = []; -- Trim the first three rows
- csvwrite(...) -- Write the csv files back
How to delete the 3 first rows of a .csv file? And how to automate it so that it does it for all the .csv files in a folder that has also subfolderd containing .csv files?
23 views (last 30 days)
Show older comments
Hi,
I am new to Matlab, and I would appreciate any kind of help. I have a lot of .csv files in an folder, that also has a lot of subfolders containing .csv files. Each of the .csv files have unimportant data on the first 3 rows. I would like to create a code that would search through these files and delete these rows. Can you give me help to get to the right track.
0 Comments
Accepted Answer
the cyclist
on 31 Jul 2013
Edited: the cyclist
on 31 Jul 2013
Here is a rough outline of what you need:
I suggest you try this (be sure you have file backups first!), and then post new questions on each step, if you get stuck.
More Answers (1)
nasib dar
on 29 Apr 2019
Delete first 2 rows of multiple csv in Excel, here is full video https://www.youtube.com/watch?v=2mx9bZ7xz5o&t=38s
0 Comments
See Also
Categories
Find more on Spreadsheets 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!