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?

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.

Answer 1

[the cyclist]

Here is a rough outline of what you need:

• 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

I suggest you try this (be sure you have file backups first!), and then post new questions on each step, if you get stuck.

[Nico]

Ok, thanks. I'll try to figure it out from here.

Answer 2

[nasib dar]

Delete first 2 rows of multiple csv in Excel, here is full video https://www.youtube.com/watch?v=2mx9bZ7xz5o&t=38s