UNIX for Advanced & Expert Users

I have a code as follows

awk ' BEGIN{FS=OFS=","}
{
n=split($3,a1,"~")
split($4,a2,"~")
split($5,a3,"~")
for(i=1;i<=n;i++) {
print $1,$2,a1[i],a2[i],a3[i],date
}
}' file

In the above code I need to add current date(date). How is this possible to call an date or a exported value inside awk.

Code:

awk -v date=$(date +%Y%m%d) 'BEGIN ...

Adjust the command to print the date in the format you want it. +%Y%m%d looks like 20080416 -- see the date manual page for the available options.

awk -v RD=$(date +%Y%m%d) 'BEGIN{FS=OFS="|"}
{
n=split($7,B_ID,"~") split($8,B_VAL,"~") split($9,B_COS,"~")
for(i=1;i<=n;i++)
{
print $1,$2,$3,$4,$5,$6,B_ID[i],B_VAL[i],B_COS[i],$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$
28,$29,$30,$31,$32,$35,$36,$37,$38,$RD
}
}' $Source_Path/EServe_0CCS_IN_${FD_WH}_$HR1$HR2.TXT > $Target_Path/R_GPC_$3_${HR1}_${HR2}.dat

It gives me an error

syntax error at line 9: `(' unexpected

The syntax error appears to be unrelated. Please put that inside [CODE] tags so it's easier to see what's where. Looks to me like you have only 8 lines; did you cut out other stuff and if so which line is line 9?

If your shell doesn't understand $(...) try with backticks instead;

Code:

RD=`date +%Y%m%d`

By the way, in the awk script, you want RD, not $RD

You can also use getline to retrieve the current date as in the following example

Code:

BEGIN {
    "date" | getline cur_date
    close("date")
}
{
     print cur_date
}

Dear era

Here is the code

Code:

awk -v rd=`date` ' BEGIN{FS=OFS=","}
{
n=split($3,a1,"~")
split($4,a2,"~")
split($5,a3,"~")
for(i=1;i<=n;i++) {
print $1,$2,a1[i],a2[i],a3[i]
}
}' Myin.txt

This give me following error

awk: syntax error near line 1
awk: bailing out near line 1

If I remove the bolded code,its working properly?

if on Soalris, use either /usr/bin/nawk or /usr/xpg4/bin/awk