Shell Script - Parsing Question

[Praveen Hari]

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

[Hai Nguyen_1 · Accepted solution]

Try this

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

output is in new_file

Hai

[Praveen Hari]

It worked. Thanks

[Hai Nguyen_1]

Try another way:

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

Hai

[Praveen Hari]

It worked. Thanks

[Praveen Hari]

It worked. Thanks

[James R. Ferguson]

Hi:

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

Regards!

...JRF...

[James R. Ferguson]

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

[James R. Ferguson]

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

[H.Merijn Brand (procura]

# 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