Shell Programming and Scripting

Hi,
I am trying something like:

c=`awk -F"|" '{ print NF }' test.txt`
echo "c is $c"
if [ c > 2 ]
then
echo "More than One field"
else
echo "One field"
fi

The test.txt file has something like:
lkadaldj|
fdsakfdsafd|
ddddddd|

The value of "c" is 2 in above case. If any rows in the file has more than 2 columns(something like: lkadaldj999|2345| ) then it should get inside "if" condition.

But the above code is bypassing the "if condition for all the rows" and getting inside the "if" statement even if the value of "c" is 2 for all the rows. I am getting "More Than One Field" as an answer even if all the rows are having two columns. I am using ksh.

I also tried something like:
if test $c -gt 2 ---> I get error :test: 2: unknown operand"

I will really appreciate any help in correcting this code.

Thanks
Raj

You may have to try some thing like this:

Code:

 awk -F"|" '{ if (NF >2 ) { print "More than One field" }else { print "One field }
}' test.txt

When comparing integers, use the notation: -gt (greather than), -lt (less than), -ge (greater than or equal), etc. Also, to access the value of a variable, you must prefix the variable with a $ sign. The quotes around the code example below are there in the event that c is null (not set). Since the shell will expect a value, the quotes will basically say, no value. Otherwise you will get an error back from the shell when it attempts to make the comparison.

Change this line:

Code:

if [ c > 2 ]

To:

Code:

if [ "$c" -gt "2" ]

This isnt the problem in your shell but using back ticks is old school and is less readable than the new form. New form also allows nesting of variables which is pretty powerful.

old
c=`awk -F"|" '{ print NF }' test.txt`
new
c=$(awk -F"|" '{ print NF }' test.txt)

Thanks for lot for replying so soon on this.
I changed the awk statement and the "if" statement as suggested:

#c=`awk -F"|" '{ print NF }' test`
c=$(awk -F"|" '{ print NF }' test)

echo "c is $c"

#if [ c > 2 ]

if [ "$c" -gt "2" ]
then
echo "Inside if"
else
echo "else part"
fi

I get the error below:
c is 2
2
2
2
2
[: 2
2
2
2
2: bad number
else part


But the statement below did work:

awk -F"|" '{ if (NF >2 ) { print "More than One field" }else { print "One field" }
}' test

Is there a way to provide the exit status of 2(exit 2) in the first part.Something like below. This script is called from other script and expect an exit status of 2 if there is "More than One field"

awk -F"|" '{ if (NF >2 ) { print "More than One field" exit 2}else { print "One field" }
}' test


Thanks again for the help and time in this regards.
Raj

try

Code:

awk -F"|" '{ if (NF >2 ) {print "More than a 2 fields" ; exit }else { print "one field" ; print FNR  } }' test.txt

Hi,
The statement above worked. Is there a way to make the above statement send an email. I am trying something below:

email1=`"$message3" | /usr/bin/mailx -s "$SUBJECT_EMAIL" $toMail1`
# Check for the columns in the file
awk -F"," '{ if (NF >2 ) {print "$email1" ; exit 2 }else { print "one field" ; print FNR } }' $file1


Thanks
Raj