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?

16 次查看（过去 30 天）
Nico
Nico 2013-7-31
回答： nasib dar 2019-4-29
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.

请先登录，再回答此问题。

采纳的回答

the cyclist
the cyclist 2013-7-31
编辑：the cyclist 2013-7-31
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.

更多回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by