want to send mail if all values in second field are zero

saurabhmehan · 09-01-2010, 03:02 AM

In my file there are 2 fields separated by space.
Sample content of file are as follows:
56060 1
54242 0
53030 0

Now i want to check second field of the file and if all values in second field are 0(zero) and send mail containing all contents of the file

xeleema · 09-01-2010, 03:12 AM

Greetingz!

Gee, this sure looks like a homework assignment...what is that data from?
As for "how to do it", you can utilize for-loops and if-then statemens within the Korn shell.

Code:

#! /usr/bin/ksh
export FILE_TO_CHECK=/absolute/path/to/the/filename
export ZERO_IN_FIELD_TWO_PRESENT=0
printf "Scanning $FILE_TO_CHECK\n"
for x in $(awk '{print $2}' ${FILENAME_TO_CHECK} )
do
  if [ $x -eq 0 ]; then
    printf "There is a zero in field two. File will be emailed out. Continuing scan...\n"
    export ZERO_IN_FEILD_TWO_PRESENT=1
  fi
done
printf "Scan of $FILE_TO_CHECK completed.\n"
if [ $ZERO_IN_FIELD_TWO_PRESENT -eq 1 ]; then
   mailx -s "subject line you want in the email" email@address.to.mail.to
   printf "$FILE_TO_CHECK has been emailed.\n"
fi
# End of File.

druuna · 09-01-2010, 03:28 AM

Hi,

And a bash/awk solution:

Code:

#!/bin/bash

inFile=/path/to/infile

allZeroCheck=$(awk 'BEGIN { allzero = "true" }
{ if ( $2 != "0" ) { allzero = "false" ; exit } }
END { print allzero }' $inFile )

if [[ "$allZeroCheck" == "true" ]]
then
   cat $inFile | mailx -s "subject goes here" x@y.z
fi

Hope this helps.

r_s · 09-01-2010, 06:53 AM

way easy to do in C/C++ or python, if language is not the restriction.