Basic linux/ awk Question

Here is a bash version...

#!/bin/bash
while read line; do
        two=`echo $line | awk '{print $2}'`
        if [ "$two" = "0" ]; then
                echo '$2 is 0'
        else
                echo 'used'
        fi
done

Select allOpen in new window

Your can run it like this:

./script.sh < file.txt

You can change it to meet your needs.

I'm not sure if I understand your goal. This is how I'm interpreting your pseudo code:

1) Assuming we have an input file containing 10 rows, and none to nine of them contain "0" in the second column, what should be the final result? According to your question it should be just the word "used".
2) Assuming we have an input file containing 10 rows, and all of them contain "0" in the second column,
what should be the final result? According to your question it should be the number "10" (= the total number of rows in the file).

Is that correct? If so try this:

awk '{if($2!~/0/) sg="used"; else count++} END {if(sg) print sg; else print count}' file.txt
or shorter
awk '{if($2!~/0/) sg="used"} END {if(sg) print sg; else print NR}' file.txt

If my assumptions above are incorrect please explain a bit clearer what you're after.

wmp

This got me to where was going:

awk '{if($2!~/0/)xcount++}END{if(xcount)print "used",xcount}' file.txt

This pointed me in the right direction:
awk '{if($2!~/0/)xcount++}END{if(xcount)print "used",xcount}' file.txt