RECORD=NEW|~|VENDORN=LUCENT|~|VENDORM=CBX500_REAR|~|NETWORK=ATM|~|SUBNETWORK=N/A|~|SITE=CIL|~|REGION=KN|~|COUNTRY=PS|~|SWITCH=SWITCH1|~|E
THERNET=N/A|~|LOOPBACK=N/A|~|SHELF=N/A|~|SLOT=14|~|SUBSLOT=N/A|~|STSCHAN=N/A|~|PORT=S14|~|DS1SLOT=N/A|~|LINE=N/A|~|LPORTID=N/A|~|CARDDESC=N/A|~|CARDTYPE=BAC2RT0
E|~|ENCAPSULATION=ATM|~|BUNDLEID=N/A|~|PORTUSE=N/A|~|STATUS=T|~|MANAGED=YES|~|BILLINGID=N/A|~|CKTID=5HCSILHR02W|~|CKTIP=N/A|~|PORTSERVICE=B3ZS|~
|SPEED=0|~|CHNLS=N/A|~|NX_KEY=3|

I have the following record in a file which is delimited by |~| , I would like to print only the second (VENDORN=LUCENT) and third field (VENDORM=CBX500_REAR) in this record.


nawk '{FS="|~|"; print$2 $3}' filename

nawk: illegal primary in regular expression |~| at ~|
input record number 1, file filename
source line number 1


Looks like because this delimiter has a ~ sign in between it doesnt work.

How do I make |~| as the delimiter. anyhelp is appreciated folks.

The OS I am on is SunOS 5.10

And if you try:

?

nawk -F'|~|' '{print$2 $3}' filename
nawk: illegal primary in regular expression |~| at ~|
input record number 1, file filename
source line number 1

Both awk and gawk work for me

Thanks , after using awk, gawk in the following directory. it does work.

/usr/xpg4/bin/awk

/usr/xpg4/bin/awk -F'|~|' '{print$2}' filename
VENDORN=LUCENT

this is what I wanted. works for me.


/usr/local/bin/gawk -F'|~|' '{print$2}' filename
|VENDORN=LUCENT|

gawk put "|" pipe symbol in the output which I dont want.

which awk
/usr/bin/awk
awk -F'|~|' '{print$2}' filename
~

Why not use

awk -F\| '{print $3}'