exclude a line

Shell Programming and Scripting
1

Hi,
thanks for your help. I wrote this script :

# ! /bin/sh
file=snapshot.txt
cat $file | while read line ;
do
{
myvariable=`grep "Nombre de ROLLBACK internes" |sed 's/.*.=//'`
echo $myvariable
}
done

It looks in a file "snapshot.txt" for the lines containing "Nombre de ROLLBACK internes". But there are two lines containing this :
Nombre de ROLLBACK internes = 0
Nombre de ROLLBACK internes dus � interblocages = 7

How can I exclude the following line :
Nombre de ROLLBACK internes dus � interblocages = 7

This my snapshot.txt file :

Num. de partition de base de donn�es du catalogue       = 0
Nom du catalogue du noeud r�seau                        =
Syst. d'exploitation serveur de base de donn�es         = NT
Nombre de ROLLBACK internes = 0
Nombre de ROLLBACK internes dus � interblocages = 7
Emplacement de la base de donn�es                       = Local
Horodatage de la premi�re connexion � la base     = 18.04.2008 05:31:56.832765

Regards.

2

one way

myvariable=`grep "Nombre de ROLLBACK internes" | grep -v "dus � interblocages" | sed 's/.*.=//'`
3

Some possibilties:

grep 'Nombre de ROLLBACK internes =' snapshot.txt |cut -d" " -f6

awk '/^Nombre de ROLLBACK internes =/{print $6}' snapshot.txt

sed '/^Nombre de ROLLBACK internes = /s/.*= //' snapshot.txt

Regards

4

thank you.