I have an awk statement where I Need to pass an environment variable but I cannot get it to work:

My evironment varible examples below:
$FILE1=/dev/fs/file.new
$FILE2=/dev/fs/file.old

Code below:

awk -F"|" '
BEGIN {
while( getline < "$FILE1" )
{ arr[$1]=1 }
}
arr[($1)] != 1 { print }
' $FILE2


I cannot hard code the file names into the awk statement. I need to apss the file name as a varibale. but my above awk is not reading $FILE1 as the value it is defined as in the environment.

THank you for the reply.

Unfortunately I am running ina UNIX emulator WIndows Services for Unix. It does not ahve nawk. can this be done in awk?

worth tryin', ain't it?

I did after I sent the reply. Sorry should have thought before I typed.

and....? the verdict is....???

Yes that would help. you can tell I am a newbie. Works great. I changed it slightly but it works.

awk -F'|' '
NR==FNR { arr[$1]=1; next }
arr[$1] !=1' $HOME/$WORK/$NewFile $HOME/$COMPARE/$OldFile > $HOME/$WORK/$NewFile.del

The above compares yesterdays file to todays and find deleted records.

Thanks very much for the help.