UrgentPlease: compare 1 value with file values eliminating special characters

kittusri9 · #1 (**permalink**) 04-25-2008

Hi All,

I have file

i have values like
----
112
113
109
112
109

I have another file
cat supplierDetails.txt
-------------------------
112|MIMUS|krishnaveni@google.com
113|MIMIRE|krishnaveni@google.com
114|MIMCHN|krishnaveni@google.com
115|CEL|krishnaveni@google.com
108|UGEN|krishnaveni@google.com
109|SLAND|krishnaveni@google.com

I need to compare above values to this file first column values
like
if 112=112 then
i need to print MIMUS
like i need to validate above all values to this file,
I need it in loop

Please help me

Thanks
Krish.

Franklin52 · #2 (**permalink**) 04-25-2008

Code:

awk -F"|" 'NR==FNR{arr[$0];next}$1 in arr{print $2}' file1 upplierDetails.txt

Regards

Shivdatta · #3 (**permalink**) 04-25-2008

Code:

for val in `cat file1`
do
grep $val supplierList.txt | awk -F"|" '{print $1,$2}' 
done

kittusri9 · #4 (**permalink**) 04-25-2008

Hi,

Once i got the values
i need to mail this result like
mail -s "Gateway messaging: $2" krish@google.com

is it possible

please answer it.

Thanks krish.

Shivdatta · #5 (**permalink**) 04-25-2008

U can redirect the printed values to a file
i.e

Code:

grep $val file2 | awk -F"|" '{print $1,$2}' >>tempfile

and later use

Code:

mailx  -s "Gateway messaging:" -r  krish@google.com < tempfile

kittusri9 · #6 (**permalink**) 04-25-2008

i used mailx is not working

again i used this one
mail -s "Gateway : $2" $Email < $tempfile

it says that

exam5.sh: line 4: $tempfile: ambiguous redirect

Is there any other option

kittusri9 · #7 (**permalink**) 04-25-2008

My requirement is
112|MIMUS|krishnaveni@google.com

if val =112
then i need to send mail to
subject:MIMUS mail to Krishnaveni@google.com

is it possible

if val=113
then i need to send mail to
subject=MIMIRE mail to krish@google.com

i need it like this

Can you help me how to do this.

thanks
krish.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
escaping special characters in file name...	lau0001	Shell Programming and Scripting	1	01-19-2008 08:54 PM
Removing special characters in file	srivsn	Shell Programming and Scripting	6	01-03-2008 06:10 AM
How to delete a file with special characters	yveslagace	UNIX for Dummies Questions & Answers	5	08-22-2007 11:42 AM
how to see special characters in a file using vi	jingi1234	UNIX for Dummies Questions & Answers	6	10-19-2005 11:57 AM
search special characters in a file	cramya80	UNIX for Dummies Questions & Answers	2	05-13-2005 12:08 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: