Shell Programming and Scripting

Hi All

I have what seems to be something quite trivial but for the life of me can't work out a solution.

Basically, I have the following script that reads a version report that contains certain flags. If a condition is true, I want to print the value of column 2, sort them uniquely and return the penultimate line from that file.

This is a sample of the input

Code:

MR,dynamic.20090811.0554,TRUE,FALSE,TRUE
MR,dynamic.20090817.0734,TRUE,FALSE,TRUE
MR,dynamic.20090818.0808,TRUE,FALSE,TRUE
MR,dynamic.20090818.0808,TRUE,FALSE,TRUE

I can do everything except return the second line. This is sample of the script I am using. I redirect my output from the read statement into a temporary file, sort that file and then from there I want to return the row i want. I'm not sure if is the most efficient but .

Code:

while read event; do

is_ph_true=`echo $event | cut -f5 -d,`

        if [ $is_ph_true = "TRUE" ]; then
                `echo $event | cut -f2 -d, >> tmp`
        fi
done<versions.report

                sort -u tmp

This is where I'm stuck. Any help as usual will be appreciated.

tia.

Code:

nawk -F, '$NF=="TRUE" {print $2}' versions.report | sort -u | tail -2 | head -1

OR

Code:

nawk -F, '$NF=="TRUE" {print $2}' versions.report | sort -u | sed -e '$!{h;d;}' -e x

excellent thanks. I'll give that a try. Thank you.