awk Help

Shell Programming and Scripting
1

Hi,

The desired output i am trying to get is as below but the awk i am trying does not get the desired result.

awk '
/NE name:/ {
        n = $4
	}
/"To/ {
        split($0, t, /[,":]/)
        print n, t[2], t[8], t[18], t[19], t[20], t[21], t[22], t[23], t[24]
		
}' OFS=, /cygdrive/c/output/a/output.txt >>$i


AB1S2a	FAC-12-1	AREA=0.0.0.3		To AB2S2a SL6 P1-1	
AB2S2a	FAC-12-1	AREA=0.0.0.3		To AB3S2a SL6 P1-1
AB2S2a	FAC-6-1-1	AREA=0.0.0.3		To AB1S2a SL12 P1-1
ABHS2a	FAC-13-1-1	AREA=0.0.0.3		To ABHS1a SL4 P3-1

And this the input .



spawn telnet 172.17.38.104 3083

### NE name: ABHS1a ###

"FAC-12-1:,,,:DCC=N,AREA=0.0.0.3,TMGREF=Y,SYNCMSG=Y,SENDDUS=N,PJMON=0,SFBER=1E-4,SDBER=1E-7,MODE=SDH,WVLEN=1550.00,MUX=K3,UNIC=N,SOAK=32,SSMRCV=G811,OSPF=Y,MSDCC=Y,NAME=\"To AB2S2a SL6 P1-1\",SENDDUSFF=N,AISONLPBK=FACILITY,FOREIGNFEND=N,OSISDCC=N,OSIMSDCC=N,:unlocked-enabled,"
"FAC-12-1:,,,:DCC=N,AREA=0.0.0.3,TMGREF=Y,SYNCMSG=Y,SENDDUS=N,PJMON=0,SFBER=1E-4,SDBER=1E-7,MODE=SDH,WVLEN=1550.00,MUX=K3,UNIC=N,SOAK=32,SSMRCV=G811,OSPF=Y,MSDCC=Y,NAME=\"To AB3S2a SL6 P1-1\",SENDDUSFF=N,AISONLPBK=FACILITY,FOREIGNFEND=N,OSISDCC=N,OSIMSDCC=N,:unlocked-enabled,"
"FAC-6-1-1:,,,:DCC=N,AREA=0.0.0.3,TMGREF=Y,SYNCMSG=Y,SENDDUS=N,PJMON=0,SFBER=1E-4,SDBER=1E-7,MODE=SDH,MUX=K3,UNIC=N,SOAK=32,SSMRCV=DUS-SDH,OSPF=Y,MSDCC=Y,NAME=\"To AB1S2a SL12 P1-1\",LBCL=55.006,OPT=2.478,OPR=-13.904,TRCMODE=OFF,TRCFORMAT=16-BYTE,SENDDUSFF=N,AISONLPBK=FACILITY,FOREIGNFEND=N,FREQ=1550,LOSSB=L2,OSISDCC=N,OSIMSDCC=N,:unlocked-enabled,"
"FAC-13-1-1:,,,:DCC=N,AREA=0.0.0.3,TMGREF=N,SYNCMSG=Y,SENDDUS=N,PJMON=0,SFBER=1E-4,SDBER=1E-7,MODE=SDH,MUX=K3,UNIC=N,SOAK=32,SSMRCV=STU,OSPF=Y,MSDCC=Y,NAME=\"To ABHS1a SL4 P3-1\",LBCL=36.750,OPT=-3.340,OPR=-4.472,TRCMODE=OFF,TRCFORMAT=16-BYTE,SENDDUSFF=N,AISONLPBK=ALL,FOREIGNFEND=N,FREQ=1310,LOSSB=I1,OSISDCC=N,OSIMSDCC=N,:unlocked-enabled,"
2

Try this adaptation of your script:

awk '
/NE name:/ {
        n = $4
        }
/"To/ {
        gsub(/\\*"/,x)
        m=split($0, t, /[,:]/)
        for(i=1; i<=m; i++) if(sub(/NAME=/,x,t)) break
        print n, t[1], t[7], t
                
}' OFS='\t' /cygdrive/c/output/a/output.txt >>$i

output:

ABHS1a	FAC-12-1	AREA=0.0.0.3	To AB2S2a SL6 P1-1
ABHS1a	FAC-12-1	AREA=0.0.0.3	To AB3S2a SL6 P1-1
ABHS1a	FAC-6-1-1	AREA=0.0.0.3	To AB1S2a SL12 P1-1
ABHS1a	FAC-13-1-1	AREA=0.0.0.3	To ABHS1a SL4 P3-1

Note that in your output sample column 1 does not seem related to either your input file or your script sample...

3

Thanks for the help very much.....But i am trying put this in a CSV and output i am trying to get is comma separated and i am trying also squeeze in this input too which extension of my previous input and Thanks in advance.

   "FAC-11-1-1-1:,,PROT,STBY:DCC=N,TMGREF=N,SYNCMSG=Y,SENDDUS=N,SFBER=1E-4,SDBER=1E-7,MODE=SDH,MUX=K3,SOAK=32,SSMRCV=DUS-SDH,MSDCC=N,NAME=\"To ARAS2b SL13 P1-1\",TRCMODE=OFF,TRCFORMAT=16-BYTE,SENDDUSFF=N,FREQ=1310,LOSSB=I1,OSISDCC=N,OSIMSDCC=N,:unlocked-enabled,"
   "FAC-11-2-1-1:,,PROT,STBY:DCC=N,TMGREF=N,SYNCMSG=Y,SENDDUS=N,SFBER=1E-4,SDBER=1E-7,MODE=SDH,MUX=K3,SOAK=32,SSMRCV=DUS-SDH,MSDCC=N,NAME=\"To ARAS2c SL13 P1-1\",TRCMODE=OFF,TRCFORMAT=16-BYTE,SENDDUSFF=N,FREQ=1310,LOSSB=I1,OSISDCC=N,OSIMSDCC=N,:unlocked-enabled,"
;

Desired Output


### NE name: ARAS1a ###

ABHS1a	FAC-11-1-1-1 	STBY:DCC=N               To AB2S2a SL6 P1-1
ABHS1a	FAC-11-2-1-1	STBY:DCC=N               To AB3S2a SL6 P1-1