Shell Programming and Scripting

Hi all,

I currently have the following script in 1) which outputs to a file if the 3rd column is equal to the message_id value. This works. However what I want to do is incorporate an else statement and output to a different file if the 3rd column doesnt equal the message_id values. I tried that script shown in 2) but it doesnt work. Any ideas?

1)

for message_id in 15 16 17; do
cat $path/temp/hourly_file|egrep -v "val1|val2"|awk -F, '{
if ($3=="'$message_id'")
print $0
}'|sort -t',' -k4 >> $path/temp/outputfile_msgs
done

2)

for message_id in 15 16 17; do
cat $path/temp/hourly_file|egrep -v "val1|val2"|awk -F, '{
if ($3=="'$message_id'")
print $0 >> $path/temp/outputfile_msgs
else
print $0 >> $path/temp/other_outputfile_msgs
}'
done

Many thanks!

Sorry

Yep that's what I'm trying to do but I can't get it to work with an else statement in Awk....

Code:

for message_id in 15 16 17; do
awk -F, -v msg="${message_id}" -v excl='val1|val2'  '$0 !~ excl && $3==msg' $path/temp/hourly_file |sort -t',' -k4 >> $path/temp/outputfile_msgs
done

Hi, thanks for the response.

Isn't that just doing what my original script in 1) does? What I want to do is output to a file if the 3rd coulmn does match a message_id value, and output to a DIFFERENT file if the 3rd column doesn't match one of the message_id values.

Thanks

Code:

for message_id in 15 16 17; do
awk -F, -v msg="${message_id}" -v excl='val1|val2' -v msgMatch="$path/temp/match" -v msgNomatch="$path/temp/nomatch" '$0 !~ excl { out=($3==msg) ? msgMatch : msgNomatch; print > out' $path/temp/hourly_file
done

Hi,

Thanks again.

I'm getting a syntax error. I think there's a missing curly right bracket but I don't know where it should go!