topic egrep question in Operating System - HP-UX

egrep question

bob hollis — Fri, 01 Aug 2003 10:56:30 GMT

I am using egrep to pick some information out of an Oracle export.
I am using the following:
cat export.dmp|egrep "F983051|F98306|F98720|F98740|F98741|F98743"
What is the maximum length of the string I can use? It seems if I put too many table names in the string I get no results.
Any other ideas how to do this?

Re: egrep question

Massimo Bianchi — Fri, 01 Aug 2003 10:57:51 GMT

You can use a file, with the option -f "filename"

Massimo

Re: egrep question

Massimo Bianchi — Fri, 01 Aug 2003 11:01:24 GMT

Hi,
thinking a little more: would it ne more usefull if you do a fake import ?

egrep-ping an oracle dump is not very usefull, but an import with

indexfile=file1.txt show=y

will be more usefull

Massimo

Re: egrep question

Francisco J. Soler — Fri, 01 Aug 2003 11:12:16 GMT

Hi, you can do it with awk.

cat export.dmp | awk '
/F983051/
/F98306/
/F98720/
/F98740/
/F98741/
/F98743/
....
'

It is not needed the print statement because is the default one.

HTH
Frank

Re: egrep question

john korterman — Fri, 01 Aug 2003 11:42:35 GMT

Hi Bob,
I do not know the limit, but perhaps you can shorten your reg. expression string by organizing it for matching ranges, e.g.:
# egrep "F9830[5-6]*|F987[1-2][0-1]" export.dmp

which will match the strings:
F98305 + whatever comes after
F98306 + whatever comes after
F98710
F98711
F98720
F98721

Regards,
John K.

Re: egrep question

Caesar_3 — Sat, 02 Aug 2003 19:03:50 GMT

Hello!

You can use perl,

open (FH, filename);

foreach ()
{
if (/F983051|F98306|F98720|F98740|F98741/)
{
print "Found: $_";
}
}
close (FH);

Caesar