Shell Programming and Scripting

How can i scan a file in a UNIX script and look for a particular keyword?

For example if i wanted to scan the file "lpcmp165.out" and see if it contains the term "error" or "ERROR" and then return a 0 or 1 or some indicator as such?

Detail example:
sqlplus -s xx/yyyyyyy#@zzz <<EOF > lpcmp165.out
set pagesize 0 feedback off verify off heading off echo off
set serveroutput on
DROP INDEX PKM_TCQ_DT_TPD_LOAN_EXLOAN_ID;
commit;
exit;
EOF

if [ lpcmp165.out contains "error" ] ; then <<<<< psuedo code
echo "bad result"
else
echo "good result"
fi

lpcmp165.out contains this output:
DROP INDEX xPKM_TCQ_DT_TPD_LOAN_EXLOAN_ID
*
ERROR at line 1:
ORA-01418: specified index does not exist

Code:

egrep "error|ERROR" lpcmp165.out 1>/dev/null 2>&1
mRetCode=$?
if [ $mRetCode -eq 0 ]; then
  echo 'Found'
else
  echo 'Not found'
fi

wow! thanks again ShellLife! works great!

can't say enough how helpful you've been over time, saved me many hours!

have a great week!

BobK

this site should hire you full time or set up some kind of Kudo's or donate button!

Thank you for your kind words, BobK.

Our satisfaction is to see your problems resolved.

Take care!

ignore case -i option with grep

Code:

if [ `grep -i error filename 1>/dev/null 2>&1` -eq 0 ]
then
echo "found"
else
echo "not found"
fi

I think you meant

Code:

if grep -i error filename 1>/dev/null 2>&1
then
echo "found"
else
echo "not found"
fi