appending multiple *.csv files while retaining the original file name in the first column

[ShotSimon]

Hi guys it's been awhile.

I'm trying to append multiple *.csv files while retaining the original file name in the first column, the actual data set is about 40 files.

file a.csv contains:
1, line one in a.csv
2, line two in a.csv

file b.csv contains:
1, line one in b.csv
2, line two in b.csv

output.csv result is this:

I would like this:
a.csv, 1, line one in a.csv
a.csv, 2, line two in a.csv
b.csv, 1, line one in b.csv
b.csv, 2, line two in b.csv

Any suggestions to speed up my hobbling attempts would be aprieciated:)

Thanks,

-SS

[ABCPrograms · Accepted solution]

What you could do is given in the attachment.

Started with 2 files :

a.csv

copy of a.csv

Both with data :

1;1.123

2;2.234

3;3.345

Output :

a.csv;1;1.123 a.csv;2;2.234 a.csv;3;3.345 Copy of a.csv;1;1.123 Copy of a.csv;2;2.234 Copy of a.csv;3;3.345

If you have more questions, just shoot 😉

[ShotSimon]

ABCPrograms,

Very nice solution Thank you.

-SS

[ABCPrograms]

Was the solution the answer to your question?

Kind regards,

Bjorn

[ShotSimon]

Yes.  -SS