A grep Question

[GerGon]

Hi ...

I get listener.ora file, I need to extract, only connections done by sql or sqlnav, but no include user like xx,yyy,zz,mmm,etc..

I wrote in HP-UX v11:
cat listener.log | grep -v "hbeans|lsmith" > a1
or
cat listener.log | grep -i sjones -v 'hbeans|lsmith' > a1

But, it does not work, a1 file have nothing.. I probe with single qoute and nothing too.

Any idea...
Thanks...

[Steven E. Protter]

try

cat listener.log | grep -v hbeans | grep -v lsmith > a1

Should work

SEP

[Sundar_7 · Accepted solution]

hbeans|lsmith is an extended regular expression that grep will not support.

use egrep

cat listener.log | egrep -i "hbeans|lsmith" >> a1

[Sundar_7]

To use Extended Regular expressions with grep, you need to use -E/-e options.

[john korterman]

Hi,

and it would work faster without cat, e.g.:
# grep -Eiv "hbean|smith|jones" listener.log >a1

regards,
John K.

[John Kittel]

You can also use multiple -e arguments with -v, so this works as well:

cat listener.log | grep -v -e "hbeans" -e "lsmith" > a1

And, BTW, not exactly related to your question, but interesting and useful nonetheless...

It is a rather classic misuse or inefficiency to start pipelines with cat in this way. grep takes an input file argument. So something like this for exmple:

cat listener.log | grep -v -e "hbeans" -e "lsmith" > a1

is better written as this:

grep -v -e "hbeans" -e "lsmith" listener.log > a1

[GerGon]

Thanks a lot to all..