topic Re: Shell Script - Parsing Question in Operating System - HP-UX

Shell Script - Parsing Question

Praveen Hari — Thu, 28 Aug 2003 17:16:24 GMT

I have a file of format

[0:2] x.x.a start=3 end=50 items=47 aaa bbb ccc
[3:4] x.x.b start=20 end=70 items=50 aaa bbb ..

I want to parse this and create a new file with the format

x.x.a 50
x.x.b 70

Please note that I want to extract the second string and number in 4th string and ignore rest of the line and write into a new file.
How do I do it in Shell Scripts ?
I am a beginner in Shell Scripts..
Any help is appreciated..

Re: Shell Script - Parsing Question

Hai Nguyen_1 — Thu, 28 Aug 2003 17:19:35 GMT

Try this

# sed 's/end=//' your_file | awk '{print $2 " " $4}' > new_file

output is in new_file

Hai

Re: Shell Script - Parsing Question

Praveen Hari — Thu, 28 Aug 2003 17:28:07 GMT

It worked. Thanks

Re: Shell Script - Parsing Question

Hai Nguyen_1 — Thu, 28 Aug 2003 17:28:08 GMT

Try another way:

# cut -d" " -f2,4 your_file | sed 's/end=//' > new_file

Hai

Re: Shell Script - Parsing Question

Praveen Hari — Thu, 28 Aug 2003 17:28:24 GMT

It worked. Thanks

Re: Shell Script - Parsing Question

Praveen Hari — Thu, 28 Aug 2003 17:28:49 GMT

It worked. Thanks

Re: Shell Script - Parsing Question

James R. Ferguson — Thu, 28 Aug 2003 17:38:12 GMT

Hi:

# awk -F"=" 'awk -F= {split($1,a," ");X=a[2];split($4,a," ");print X,a[1]}' inputfile

Regards!

...JRF...

Re: Shell Script - Parsing Question

James R. Ferguson — Thu, 28 Aug 2003 17:40:15 GMT

Hi (again):

Oops. that should be:

# awk -F"=" 'awk -F= {split($1,a," ");X=a[2];split($3,a," ");print X,a[1]}' inputfile

Regards!

...JRF...

Re: Shell Script - Parsing Question

James R. Ferguson — Thu, 28 Aug 2003 17:41:03 GMT

Hi (again):

Oops. that should be:

# awk -F"=" 'awk -F= {split($1,a," ");X=a[2];split($3,a," ");print X,a[1]}' inputfile

Regards!

...JRF...

Re: Shell Script - Parsing Question

H.Merijn Brand (procura — Thu, 28 Aug 2003 19:17:21 GMT

# perl -pe's/^\s*\S+\s+(\S+)\s+\S+\s+.*?(\d+).*/$1 $s/' infile

or if the 'end=' is always 'end=', and there will never be leading whitespace

# perl -pe's/^\S+\s+(\S+).*?end=(\d+).*/$1 $2/' inile

It's not always awk/sed/sh :))

Enjoy, have FUN! H.Merijn