AWK - append system date to fields

tpb · #1 (**permalink**) 10-07-04, 15:23

Can anyone please help me figure out how to append the system date to a file. systime() does not work with awk.

I have something like this already:

awk -F'|' '

BEGIN { baanid = " " }

{
printf ("%s%s\n"\
,$0,"|SPCA|")
}

END {
printf ("%s\n"\
,$0)
}' test.dat > test1.dat

-------------------------------------

INPUT FILE:

100000|MALEGOVD
100001|TESTING

CURRENT OUTPUT FILE RESULTS:

100000|MALEGOVD|SPCA|
100001|TESTING|SPCA|

WHAT I WANT:

100000|MALEGOVD|SPCA|10/07/2004
100001|TESTING|SPCA|10/07/2004

I'm really hurting on this one, I am new to AWK and UNIX and have been trying for two frig'n days.

vgersh99 · #2 (**permalink**) 10-07-04, 16:17

Quote:

Originally Posted by tpb

Can anyone please help me figure out how to append the system date to a file. systime() does not work with awk.

I have something like this already:

awk -F'|' '

BEGIN { baanid = " " }

{
printf ("%s%s\n"\
,$0,"|SPCA|")
}

END {
printf ("%s\n"\
,$0)
}' test.dat > test1.dat

-------------------------------------

INPUT FILE:

100000|MALEGOVD
100001|TESTING

CURRENT OUTPUT FILE RESULTS:

100000|MALEGOVD|SPCA|
100001|TESTING|SPCA|

WHAT I WANT:

100000|MALEGOVD|SPCA|10/07/2004
100001|TESTING|SPCA|10/07/2004

I'm really hurting on this one, I am new to AWK and UNIX and have been trying for two frig'n days.

Code:

nawk '

  BEGIN { 
     FS=OFS="|";
     baanid = " "
     cmd=""date +%m/%d/%Y"
     cmd | getline curDate; close(cmd);
  }

   {
        printf ("%s%s%s\n"\
               ,$0, "SPCA", curDate) 
   }

END   {
        printf ("%s\n"\
               ,$0)                           
      }' test.dat > test1.dat

date +%m/%d/%Y

vgersh99 · #3 (**permalink**) 10-07-04, 16:19

ooops, sorry:

change:

Quote:

cmd=""date +%m/%d/%Y"

TO:

Code:

cmd="date +%m/%d/%Y"

Internet Services

Web Development

Digital Marketing

Consumer Tech