AWK script - How to add a date format column 1

[umi6kg]

I'm very new to AWK, and not good at English.
It must be easy though I haven't solved it yet.

What I want to do is to add a column which is date,
now in %Y%m%d format. ex; 2003/01/07

$cat test.dat
a,b,c,100
a,c,e,100
b,a,c,100


a,b,c,100,2003/01/07
a,c,e,100,2003/01/07
b,a,c,100,2003/01/07

I want to save this file to 'new.dat'.

How can I code in 'adddate.awk'?

awk -f adddate.awk test.dat > new.dat


Could someone help me?

Thanks,
Suzy

 

[grega]

Here's one way. The script adddate.awk ...

# nawk script : adddate.awk

BEGIN {
IFS=","
OFS=","
}

{print $0,dt}

Run from the command line using ...

nawk -v dt=`date +%Y/%m/%d` -f adddate.awk test.dat > new.dat

Greg.

 

[CaKiwi]

Or...

BEGIN {"date +'%Y/%m/%d'" | getline dt}
{print $0 "," dt}
CaKiwi

 

[umi6kg]

It worked, thank you!

Suzy