Add columns in csv file in UNIX via AWK with special parameters

Question

I have a list of files in UNIX environment:

I want to add two more column in each files for all rows.

Assume that I have 7 csv files (could be more or less)

Each files contain below nomenclature:

123;Peter;loaisa;45678998;
145;Jhon;Stugard;654123;

I would like to add info like this:

123;Peter;loaisa;45678998;09/12/2105;filename.csv
145;Jhon;Stugard;654123;09/12/2105;filename.csv

where the value "09/12/2105" is the date of the system with this format, and the value "filename.csv" is the name of the file.

To add these columns in each file I'm using the nex below command:

sed -i "s|$|;09/12/2015;ta_55eed97631073.csv|" ta_55eed97631073.csv

But I need to execute previous command for each file that I have in my folder, and sometimes there are a lot of files.

It's possible to modify this command to get the info of the date and file name from the O.S. and assign to this command? Or is there other way to do it?

gyu-don · Accepted Answer · 2015-09-22 10:41:20Z

1

for f in * ; do sed -i "s|$|;"$(date +%m/%d/%Y)";$f|" $f ; done

answered Sep 22, 2015 at 10:41

gyu-don

7865 silver badges14 bronze badges

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

Comments

karakfa · Accepted Answer · 2015-09-22 13:20:04Z

0

awk to the rescue!

awk -vOFS=";" '{print $0,strftime("%m/%d/%Y"),FILENAME}' *.csv

answered Sep 22, 2015 at 13:20

karakfa

67.8k8 gold badges45 silver badges59 bronze badges

Collectives™ on Stack Overflow

Add columns in csv file in UNIX via AWK with special parameters

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