Shell Programming and Scripting

Hello everyone!!

I am not completely new to shell script but I havent been able to find the answer to my problem and I'm sure there are some smart brains here up for the challenge .

I have several CSV files that I need to combine into one, but I also need to know where each row came from. Let me give you an example.

Say I have file1.csv with the content:

Code:

1,a
2,b

And file2.csv:

Code:

3,c
4,d

I would like to have a file named result.csv, with the content:

Code:

1,a,file1.csv
2,b,file1.csv
3,c,file2.csv
4,d,file2.csv

The files I want to merge have different number of rows, but they all have the same number of columns, so I just need to create one new column in the result file. Any ideas??

Thank you beforehand.

/Fran