Shell Programming and Scripting

Hi All

I have a file having columns such as

Code:

AAA,BBB,CCC,Aug 13 2013
AAA,BBB,CCC,Aug 11 2013
AAA,BBB,CCC,Aug 12 2013
AAA,BBB,CCC,Aug 13 2013

Now I need to extract the records which are not of todays date (Considering Today date is 13-Aug-2013

So I should get below records

Code:

AAA,BBB,CCC,Aug 11 2013
AAA,BBB,CCC,Aug 12 2013

in a file

This is what am doing
Creating a file with only first and forth record via awk

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

Code:

cat $FILE_NAME | awk 'BEGIN{FS=",";}
{
#where = match($4,$TODAY_DATE)
#if(match)
print substr($1,1,3),"~",substr($4,1,11);}
END{;}' >> $DATE_IN_FILE

-------------------------------------
Now for comparing date am using the below

Code:

TODAY_DATE=`date +"%b %d %Y"`
cat $DATE_IN_FILE | awk 'BEGIN{FS="~";}
{
val=index($2,$TODAY_DATE)

if($val>0)
print "Inside IF"
else

print "Inside else"
;}
END{;}' >> $INCORRECT_RATE

The issue is because the Date is having multiple words Aug 12 2013 and hence Index is not working (Since Aug matches and hence it returns the value)


Please suggest

Code:

awk -F, 'BEGIN{today=strftime("%b %e %Y")} !($NF~today)' infile

--ahamed

Ahmed

Could you please explain your code.

strftime is a inbuilt function in awk to print the date in desired format, more or less similar to the date command. This will give the date in MMM DD YYYY format and stores in the variable today. All this is done in the BEGIN block since it is required to be done only once.

Then today is compared with the last field in the file. The delimiter is ,, so $NF will yield the last field.

HTH

--ahamed

Thanks a lot Ahamed, appreciate your help.

!($NF~today)
can be change to
$NF!~today
For me, its more easy to test if a field is not something,
compare to test if its equal to something then invert it.
Just a personal opinion

strftime is not necessarily available in all awk implementations. You could use a parameter (value defined by e.g. the date command) then to supply "today" into awk...