Deleting first row of each csv file using sed

Question

I am trying to delete the first row of each of my .csv files in my DIR folder using the sed:

DIR=/home/results for filename in "$DIR"; do sed 1d filename.csv done

However, this doesn't work. I am new to bash scripting and would be thankful if anyone tells me how to fix this.

Possible duplicate of How can I remove the first line of a text file using bash/sed script? — Inian
– Inian, Commented Jul 4, 2016 at 14:32

heemayl · Accepted Answer · 2016-07-04 14:11:55Z

3

Just do:

for f in /home/results/*.csv; do sed -i '1 d' "$f"; done

The glob pattern /home/results/*.csv matches all .csv files in /home/results/ directory and then the for construct iterate over the files, sed does the in place removal of the first row from each file.

answered Jul 4, 2016 at 14:11

heemayl

42.5k10 gold badges86 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

rehm20 Over a year ago

Thank you so much! This works and now I want to have a new row as a first line of this which I am trying to do by echo "col1, col2, col3" > all.csv but it doesnt work. Do you have suggestions for this?

heemayl Over a year ago

@rehm20 You could do that using sed: for f in /home/results/*.csv; do sed -i '1 s/.*/col1, col2, col3/' "$f"; done

Collectives™ on Stack Overflow

Deleting first row of each csv file using sed

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related