Shell Programming and Scripting

Please excuse my confusion, but after clearing that up it's clear that the last field is not the third field.

A clause of the effect:

Code:

!$NF { print > "test.txt" }

should work

Scottn, Can you add the if statement to my existing statement? I am not sure that can be done.

My current statement:
/usr/xpg4/bin/awk -F"[,|]" 'NR==FNR{s["\"" $1 "\""]=$2;next}{printf "%s\"%s\"\n"
, $0, s[$3]}' LOOKUP.TXT finallistnew.txt >test.txt

Thank you.

That's not a statement. It's a program!

It's not against the law to display code nicely, and as I know the local Steueramt won't tax you on it!

Code:

/usr/xpg4/bin/awk -F"[,|]" '
!$NF { print > "test.txt"; next }
NR==FNR {s["\"" $1 "\""]=$2; next}
{
  printf "%s\"%s\"\n", $0, s[$3]
}
' LOOKUP.TXT finallistnew.txt >test.txt

I would guess there, but I have a headache from reading your unformatted post.

As all input (that looks the same) comes from both files, I guess you want to apply the rule to all files.