Shell Programming and Scripting

You can try this out

Code:

awk -F"|" 'NR==FNR{arr[$0];next}$1 in arr{print $2;system("mail -s "$2" "$3"<<EOF")}' file1.txt supplierList.txt

Your error was most likely using a dollar sign $tempfile when the name of the file was just tempfile (at least in the example Shivdatta posted)

... Though, in fact you don't need a temporary file at all:

Code:

while read val
do
    awk -F"|" -v val="$val" '$0 ~ val{print $1,$2}' supplierList.txt
done <file1 | mailx  -s "Gateway messaging:" -r  krish@google.com

I cleaned up some other various crimes against humanity in that script (grep | awk, cat in backticks), some of my fixes might not work if you are on HP-UX or some other severely crippled platform; change them back if so.

Hi,

THis script works fine,
awk -F"|" 'NR==FNR{arr[$0];next}$1 in arr{print $2;system("mail -s "$2" "$3"<<EOF")}' file1.txt supplierList.txt

here no need of file1.txt file, i dont have list of values to validate
i have only one value need to validate
val=112, then i need to look into supplierList.txt file
then
subject:MIMUS and mail to krish@google.com

Please suggest me and help me. Its very urgent waiting for reply

Thanks
krish.

Perhaps I may suggest that you try the suggestion I posted before? Try it with val=112

Code:

awk -F"|" -v val="112" '$0 ~ val{print $2,$3}' supplierDetails.txt

Combining this with the earlier scripts, we might get something like

Code:

#!/bin/sh
awk -F"|" -v val="$1" '$0 ~ val{ system "mail -s '$2' '$3'" }' SupplierDetails.txt

You'd save this in a script file, mark it executable, and invoke it with the value you want (e.g. sendif 112)