File interrogation

[Sridhar Bhaskarla · Accepted solution]

Hi Cathy,

Here is the modified script. Now do not run the individual commands as you may run into syntax issues. Just modify ABCXXXX.txt to match your filename and then run the script as it is. This will generate two files. ABCXXXX.txt.good and ABCXXXX.txt.bad.

----copy below---

#!/usr/bin/ksh
FILE=ABC1390.txt
MYNAME=$(echo $FILE|awk -F "." '{print $1}'|sed 's/ABC//g')

awk -v STR="$MYNAME" -F "," '$2 == STR {print $0}' $FILE > $FILE.good
awk -v STR="$MYNAME" -F "," '$2 != STR {print $0}' $FILE > $FILE.bad

----till here---

-Sri

[cbres00]

Hi Sri.
I finally got it to work but only by using nawk rather than awk.

Thanks for your valuable assistance. Enjoy the points!

Cathy