topic A grep Question in Operating System - HP-UX

A grep Question

GerGon — Wed, 26 Jan 2005 11:58:04 GMT

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...

Re: A grep Question

Steven E. Protter — Wed, 26 Jan 2005 11:59:20 GMT

try

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

Should work

SEP

Re: A grep Question

Sundar_7 — Wed, 26 Jan 2005 12:02:12 GMT

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

use egrep

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

Re: A grep Question

Sundar_7 — Wed, 26 Jan 2005 12:04:32 GMT

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

Re: A grep Question

john korterman — Wed, 26 Jan 2005 12:18:13 GMT

Hi,

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

regards,
John K.

Re: A grep Question

John Kittel — Wed, 26 Jan 2005 12:21:22 GMT

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

Re: A grep Question

GerGon — Wed, 26 Jan 2005 15:32:22 GMT

Thanks a lot to all..