How to delete header (first row) and first column from multiple CSV files
 

I have several of csv files, I want to remove the first row (header) and first column as well. This is my code, but it overwrites the original files with no content inside:

for x in *.csv;
do
sed '1d' $x | cut -d, -f 1 > "$x";

done

Help would be highly appreciated.

You could use a temporary filename if you can think of one that's definitely not in use.

[code]
sed '1d' $x | cut -d, -f 1 > replace_$x && mv replace_$x $x
[//code]

Hi linosaurusroot,

the code: for x in *.csv; do sed '1d' $x | cut -d, -f 1 > replace_$x && mv replace_$x $x ; done is deleting the files and only retain the column 1 , I am intending to cut

Thank you: This works:

for x in *.csv; do sed '1d' $x| awk 'BEGIN{FS=OFS=","}{$1="";sub(",","")}1' > rippe_$x && mv rippe_$x $x ; done

I used your code from the earlier post
instead of

if awk:
and no sed required

Or even

I see no issue with sed either:
If you append something to 'i' option it will also make a backup, eg -i.bak

Not like you grail to use two "-e" when one would suffice .... :p