Concat multiple files and prepend filename to every line in bash

Question

There are multiple files:

1.csv
2.csv
...

With some generic content like:

[1.csv]
a
b
c

[2.csv]
d
e
f

I want to concatenate the content of the files into one file, but with the filename on every line. So the result should look something like:

[concatenated.csv]
1.csv;a
1.csv;b
1.csv;c
2.csv;d
2.csv;e
2.csv;f

Every file might have a different line count – Kiril Aug 16 '17 at 12:09 — Kiril, Aug 16 '17 at 12:09

score 7 · Accepted Answer · edited Aug 16 '17 at 12:11

7

You can use awk:

awk -v OFS=';' '{print FILENAME, $0}' *.csv

1.csv;a
1.csv;b
1.csv;c
2.csv;d
2.csv;e
2.csv;f

edited Aug 16 '17 at 12:11

John Kugelman

answered Aug 16 '17 at 12:09

anubhava

Can I make that generic to match any csv file? – Kiril Aug 16 '17 at 12:10
1

This is generic enough. `$0` prints full line. – anubhava Aug 16 '17 at 12:11

1 Answers1