editing number of csv files

[rklad77]

Hi

I have got number of .csv files with two columns and more than 10000 rows. I need to truncate each file so that it only contains data from row 3 to row 700.
The edited file should be written with the same filename.
For example

File_01 is
1,20
2,25
3,30
4,35
-,--
similarly there are File_02,File_03 and so on.

Each file should be overwritten after editing.

Thanks in advance

Rohini

 

[grega]

Quick method ...

for file in `ls File_*`
do
  head -700 $file|tail -698 > $file.tmp
  mv $file.tmp $file
done

Greg.

 

[PHV]

Try something like this:

for f in File_[0-9][0-9]; do
  echo '701,$d\n1,2d\nwq' | ex -s $f
done

Hope This Help
PH.

 

[rklad77]

Thanks it works fine.