Shell Programming and Scripting

Hi guy's

Im trying to pass variables into nawk and then match them on a value within a record but it don't seem to be working. If i put in the dates i want to see then it works fine..

#!/usr/bin/ksh -x
YEST=$(/usr/local/bin/perl -e '@T=localtime(time-86400);printf("%02d/%02d/%02d\n",$T[4]+1,$T[3],($T[5]+1900)%100)')
DATE=$(date +%m/%d/%y)
MON=$(date +%m)
DAY=$(date +%d)
YEAR=$(date +%y)

bpdbjobs -report | /usr/bin/nawk -v DATE=$DATE -v YEST=$YEST '
{
if ( NF == 13 )
if ( $12 ~ /07\/09\/05/ || $12 ~ /07\/10\/05/ || $12 ~ /07\/11\/05/)
if ( $3 ~ /Done/ && $4 > 0 )
print

elseif ( NF == 12 )
if ( $11 ~ /07\/09\/05/ || $11 ~ /07\/10\/05/ || $11 ~ /07\/11\/05/)
if ( $3 ~ /Done/ && $4 > 0 )

print

}'

I want to have the following line looking like this and using the variable, if that makes sense


if ( $12 == YEST || $12 == DATE )

print


although this doesn't work how i would like i have even tried splitting up the %d / %m / %y but still no joy. Is some control symbol used to tell awk it is a variable with a value ?

Thanks in advance...

Kenny

are you passing 'TODAY' and 'YEST ' to awk?
or are you still passing 'DATE'?

Yea just updated my post didn't quite read correct. Yea passing the variables to nawk with -v

kenny

can you print the values of 'TODAY' and 'YEST' in the 'BEGIN' block of nawk to make sure you're passing what you think you're passing? [with no leading/trailing extra chars]

I know the variables are getting there for i tried that but seems that either awk doesn't like what im trying to do with the variable for if i use

if ( $12 ~ /DATE/ )

then it thinks im matching on word DATE when i don't want this.. but im wondering if the issue is with the / for i have not exited the / with \/

For i printed date before it done the matching and show up fine..

if ( $12 ~ DATE )

looks like the or operator is causing issues then for if i have the following

if ($12 ~ DATE )

it works

But not if i have

if ($12 ~ DATE || $12 ~ YEST)

it don't work