Grep text strings between repeating lines 1

[viadisky]

Hi,

I have this data to manipulate. Basically, all I need to do is to put "SYMBOL:" and "Parent Submap:" values side-by-side.

SYMBOL: 172.21.203.8
Object Type: 3
Parent Submap: Alabama
Symbol Type: Network:IP Network
Label: 172.21.203.8
Symbol Position: 1:721x644+140+152
Hidden Value: FALSE
Submap Exists: TRUE
Background Graphics:
Layout Style: 1
Layout On: TRUE
Submap Overlay: TRUE
Show Connection Labels: FALSE
END SYMBOL
SYMBOL: 172.21.203.20
Object Type: 3
Parent Submap: New York
Symbol Type: Network:IP Network
Label: 172.21.203.20
Symbol Position: 1:721x644+92+283
Hidden Value: FALSE
Submap Exists: TRUE
Background Graphics:
Layout Style: 1
Layout On: TRUE
Submap Overlay: TRUE
Show Connection Labels: FALSE
END SYMBOL


This is the output I need:

172.21.203.8 Alabama
172.21.203.20 New York


Please help me

Cheers,
Maria

 

[PHV]

A starting point:
awk '/SYMBOL:/{s=$NF}/Parent Submap:/{print s,$NF}' /path/to/input

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[feherke]

Hi

I think there is no way to do it with [tt]grep[/tt].

sed -n '/SYMBOL/{s/.*: //;h};/Parent Submap/{s/.*: //;G;s/\(.*\)\n\(.*\)/\2 \1/;p}' /input/file
[gray]# or[/gray]
awk -F: '/SYMBOL/{s=$2}/Parent Submap/{print s,$2}' /input/file

Feherke.

http://rootshell.be/~feherke/

 

[viadisky]

Thanks for your suggestion PHV but because awk specifically greps the last field, New York became York.

I tried Feherke's awk one-liner :

awk -F: '/SYMBOL/{s=$2}/Parent Submap/{print s,$2}' /input/file

It did work! I am just a little worried on the types of data I have ... I might have a Parent Submap which looks like this:

Parent Submap: New Yorkffice1

I think only office1 will be picked ...

Thank you for your quick replies.

Cheers,
Maria

 

[feherke]

Hi

No, in that case only "New York" will be outputed, "office1" would by the third field, called $3. If you want all the rest of the line, could be easier just replacing the first field and keep the rest :

awk -F: '/SYMBOL/{s=$2}/Parent Submap/{$1=s;print}' /input/file

Feherke.

http://rootshell.be/~feherke/

 

[viadisky]

Hi Feherke,

You're right ...

I tried the one-liner awk you gave, it worked okay.


Many,many THANKS,
Maria