topic Re: Parse text in script in Operating System - HP-UX

Parse text in script

Jeff Paciolla_1 — Wed, 03 Oct 2001 12:42:20 GMT

Can anyone tell me how to return text from a log file leaving certain characters out.

Example Log File
abcd aa abcd (xxxx)

What I want to return from this entry in the log using a script is
xxxx

I don't want the parenthesis. I have been trying to do this using an awk statement, but I seem to be leaving something out.

All help is appreciated
Thanks
Jeff

Re: Parse text in script

Van de Wygaert Pieter — Wed, 03 Oct 2001 12:46:00 GMT

Jeff,

Have you tried to use single quotes?

Rgds,

Pieter

Re: Parse text in script

Jeff Paciolla_1 — Wed, 03 Oct 2001 12:50:58 GMT

i am not sure exactly what you mean by using single quotes, but I will provide a little info about the log file. It comes to me when an event takes places in my NNM network. I have no control over the format of the text message so I can't change the look. I just have to grab the info inside the ()

Thanks for your help

Re: Parse text in script

Bruce Bush — Wed, 03 Oct 2001 13:08:27 GMT

Greetings Jeff,

This pipeline is one way to do it :

cat logfile | tr -d "()" | awk '{ print $4 }'

The "tr -d" deletes whatever characters are between the double quotes.

Regards,
Bruce

Re: Parse text in script

A. Clay Stephenson — Wed, 03 Oct 2001 13:10:49 GMT

Hi Jeff:

Create an awk script like this one (I've intentionally made it more verbose than necessary for clarity) called my.awk:

{
n1 = index($0,"(")
if (n1 > 0)
{
n2 = index($0,")")
if (n2 > n1)
{
s = substr($0,n1 + 1,n2 - n1 -1)
printf("%s\n",s)
}
}
}

cat yourfile | awk -f my.awk

That should do it, Clay

Re: Parse text in script

Richard Darling — Wed, 03 Oct 2001 13:20:13 GMT

Hi Jeff,
You could do it with:

root:L1000>:awk '{print $3}' test | sed 's/)//g' | sed 's/(//g' > final

probably prettier ways to do it, but this would be quick....
RD

Re: Parse text in script

Richard Darling — Wed, 03 Oct 2001 13:21:49 GMT

Jeff, "test" would be your logfile...
RD

Re: Parse text in script

Bruce Bush — Wed, 03 Oct 2001 13:27:18 GMT

Hi Jeff,

Yet another variation in awk would be...

cat logfile | awk '{ sub(/$/, ""); sub(/$/, ""); print $4 }'

Enjoy,
Bruce

Re: Parse text in script

Robin Wakefield — Wed, 03 Oct 2001 13:45:19 GMT

Hi Jeff,

Using sed:

$ echo 'abcd aa abcd (xxxx)' | sed 's/.*($.*$).*/\1/'
xxxx

Rgds, Robin.

Re: Parse text in script

Jeff Paciolla_1 — Wed, 03 Oct 2001 14:24:52 GMT

Thanks to everybody that replied, I decided on going with the sed command. It worked great.

Jeff

Re: Parse text in script

Curtis Larson_1 — Wed, 03 Oct 2001 16:07:28 GMT

cat file | awk -F[] '{print $2;}'

Re: Parse text in script

Curtis Larson_1 — Wed, 03 Oct 2001 16:27:57 GMT

Now if all the lines aren't formated as stated:

you'll probably have to add a NF>2 as in
'NF>2 {print $2;}'

this still doesn't in sure that there is a ( ) pair. i.e. two ) or two ( on a line will still generate output. For this situation I'd use the sed suggestion also because it matches a more "exact" pattern. i.e. a () pair. Although it will only output the pattern in the last () pair on a line if there is more then one.

Re: Parse text in script

Robin Wakefield — Thu, 04 Oct 2001 06:20:41 GMT

Hi Jeff,

My reply was for processing a single line. For processing files, use:

sed -n 's/.*($.*$).*/\1/p' file

to *only* display the bracketed contents within the file.

Rgds, Robin.

Re: Parse text in script

Jeff Paciolla_1 — Thu, 04 Oct 2001 15:01:58 GMT

i appreciate everybody's help on this issue. Just one more question, shouldn't I be able to do the same thing with a NNM variable as opposed to a logfile.
Example:
instead of logfile being
abcd aa abcd (xxxx)
what if
$1 from a NNM alert was

abcd aa abcd (xxxx)

Could I do something like this

Test=$1 | `awk '{print $4}'`

Where I want to set variable Test equal to xxxx

Thanks
Jeff

Re: Parse text in script

James R. Ferguson — Thu, 04 Oct 2001 15:22:05 GMT

Hi Jeff:

# X=`echo "abcd aa abcd (xxxx)"|awk '{print $4}'`
# echo $X

...would yield "(xxxx)"

Similarly, leveraging Robin's first solution:

# Y=`echo 'abcd aa abcd (xxxx)' | sed 's/.*($.*$).*/\1/'`
# echo $Y

...would yield "xxxx"

Regards!

...JRF...

Re: Parse text in script

Jeff Paciolla_1 — Thu, 04 Oct 2001 15:38:25 GMT

Thanks James that worked perfectly

Jeff