Bulk renaming of csv files of same name using shell script

Question

I have aboout 100 .csv files with the same name in different sub directories. I need to copy all the data in these files into a single csv file but since they all have the same name they over write on each other. Can you please help me with the shell script code where i can rename all these files in order like say for example: All my files are in the name example.csv in different subfolders. I want them to be example1.csv in subfolder1, example2.csv in subfolder2 and so on...

This is the script that would over write on the csv files.

for c in *.csv
do
echo $c
cat $c >> fullreport.csv
done

Thanks a lot for your help :)

Emery Lapinski · Accepted Answer · 2013-09-11 18:12:55Z

1

"I need to copy all the data in these files into a single csv file..."

cat */example.csv > fullreport.csv

answered Sep 11, 2013 at 18:12

Emery Lapinski

1,6621 gold badge19 silver badges28 bronze badges

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

Comments

konsolebox · Accepted Answer · 2013-09-07 13:33:53Z

0

Do it this way instead:

for c in *.csv
do
    echo "$c"
    cat "$c"
done > fullreport.csv

Assuming fullreport.csv still doesn't exist. Delete it if needed.

To add more directories, just specify them space after space:

for c in *.csv a/*.csv b/*.csv
do
    echo "$c"
    cat "$c"
done > fullreport.csv

If you want to do it recursively, use find like:

while read c; do
    echo "$c"
    cat "$c"
done < <(find -type f -iname '*.csv') > fullreport.csv

You can place your output as well on a different directory instead to prevent conflicts like > ../fullreport.csv.

answered Sep 7, 2013 at 13:33

konsolebox

76.3k13 gold badges110 silver badges114 bronze badges

Collectives™ on Stack Overflow

Bulk renaming of csv files of same name using shell script

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related