Shell Programming and Scripting

I am running a query against a database and spooling it to a file.
I need to check to see if a certain value is in a specific field.

I can use awk to check the specific field.
However, part of the value changes.

Part that does not change: MYPROD
Right now I have OPS$MYPROD

But sometimes I will just have MYPROD

I do not want to grep the whole file on the off chance that a value in another field, will have MYPROD.

1. Can I do a grep on a parameter in a script?
2. if so, how do i determine does exist or doesn't exist?
3. what is the easiest way to do this?

Can't you change your query to spool only those records where the field equals what you are looking for?
I think that would be the easiest way.

How about (Checking field# 6 of file infile):

Code:

if [ "$(awk '$6~/MYPROD/{print "Found";exit}' infile)" = "Found" ]
then
     echo "Found it"
else
    echo "Not there"
fi

Thank you. I am not very good with awk. so I don't quite follow the syntax
I do understand what you are doing. Just wanted to break it down, so I can write this myself.

"$(awk '$6~/MYPROD/{print "Found";exit}' infile)" = "Found"

The only think I have used awk for is awk '{print $1}' , etc..
so let me see if i have this straight

awk '$6 -- awk on field 6
~/MYPROD/ what is '~' is that a wildcard search?
{print "Found;exit}' -- these last 2 lines look like an if-then-end if block?
infile : does the target of the awk, always go last?
I have always done
cat "filename" | awk.

thanks!

$6 ~ /MYPROD/
~ is match with regular expression, this is similar to =~ in perl. So we have field 6 matches regular expression "MYPROD".

{print "Found"; exit}
The bit in {} will only execute on lines where the proceeding expression is true. A blank expression is always true, and this is why {print $1} prints the first field of every line. Two special expressions END/BEGIN cause the following code to execute only at the end or begining of processing respectively.

This code will output the string Found\n (Note print will automatically add a newline character when outputting) and then stop processing any more lines. The exit bit avoids "Found\nFound\n" being output when you have two lines that match.

Yes, like a number of unix commands awk accepts an optional list of files to process (if none supplied standard input is processed).

Here is a little demo awk program to play with. To try it out setup files test1.txt ... testn.txt, some containing MYPROD:

Code:

awk 'BEGIN { print "Start processing Files" }
/MYPROD/ { print "File " FILENAME " Line " NR " contains MYPRO" }
END { print "All done" }' test*.txt