Sponsored Content
Full Discussion: Reformat awk output
Top Forums Shell Programming and Scripting Reformat awk output Post 302967002 by adgjmpt on Thursday 18th of February 2016 02:12:13 PM
Old 02-18-2016
Reformat awk output

I need to rearrange the output but i am unable to arrange it to match the format. In the output i need
Code:
NAME=\"To

in the column .

Bash:

Code:
#!/bin/bash

cd /cygdrive/c/output/a
cat *.txt > output.txt

i=/cygdrive/c/output/a/output.csv

#echo "NE_Name, Source, Destination, OSPF_AREA_ID" >$i


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


Output

Code:
AB1S2a	FAC-12-1	AREA=0.0.0.3	UNIC=N	SOAK=32	SSMRCV=G811	OSPF=Y	MSDCC=Y	NAME=\	To AB2S2a SL6 P1-1\
AB2S2a	FAC-12-1	AREA=0.0.0.3	UNIC=N	SOAK=32	SSMRCV=G811	OSPF=Y	MSDCC=Y	NAME=\	To AB3S2a SL6 P1-1\
AB2S2a	FAC-6-1-1	AREA=0.0.0.3	SOAK=32	SSMRCV=DUS-SDH	OSPF=Y	MSDCC=Y	NAME=\	To AB1S2a SL12 P1-1\	
ABHS2a	FAC-13-1-1	AREA=0.0.0.3	SOAK=32	SSMRCV=STU	OSPF=Y	MSDCC=Y	NAME=\	To ABHS1a SL4 P3-1\	
ABHS1a	FAC-12-1-1-1	TMGREF=N	NAME=\	To ABHS2b SL13 P1-1\		TRCMODE=OFF	TRCFORMAT=16-BYTE	SENDDUSFF=N	FREQ=1310
ABHS1a	FAC-12-2-1-1	TMGREF=N	NAME=\	To ABHS2c SL13 P1-1\		TRCMODE=OFF	TRCFORMAT=16-BYTE	SENDDUSFF=N	FREQ=1310

Input

Code:
spawn telnet 172.17.38.104 3083

### NE name: ABHS1a ###


"FAC-12-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 ABHS2b SL13 P1-1\",TRCMODE=OFF,TRCFORMAT=16-BYTE,SENDDUSFF=N,FREQ=1310,LOSSB=I1,OSISDCC=N,OSIMSDCC=N,:unlocked-enabled,"
   "FAC-12-2-1-1:,,PROT,ACT: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 ABHS2c SL13 P1-1\",TRCMODE=OFF,TRCFORMAT=16-BYTE,SENDDUSFF=N,FREQ=1310,LOSSB=I1,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 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-12-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 ABHS2b SL13 P1-1\",TRCMODE=OFF,TRCFORMAT=16-BYTE,SENDDUSFF=N,FREQ=1310,LOSSB=I1,OSISDCC=N,OSIMSDCC=N,:unlocked-enabled,"
   "FAC-12-2-1-1:,,PROT,ACT: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 ABHS2c SL13 P1-1\",TRCMODE=OFF,TRCFORMAT=16-BYTE,SENDDUSFF=N,FREQ=1310,LOSSB=I1,OSISDCC=N,OSIMSDCC=N,:unlocked-enabled,"

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help reformat data with awk

I am trying to write an awk program to reformat a data table and convert the date to julian time. I have all the individual steps working, but I am having some issues joing them into one program. Can anyone help me out? Here is my code so far: # This is an awk program to convert the dates from... (4 Replies)
Discussion started by: climbak
4 Replies

2. UNIX for Advanced & Expert Users

reformat ps output

I often use "ps -ef" command to list all running processes. Now i want to customize the output to show only 2 parts: CMD and UID as below: /bin/bash /usr/bin/run-parts /etc/cron.weekly root /usr/sbin/httpd apache /usr/sbin/httpd apache /usr/sbin/httpd apache I use ps -ef | awk '{print $8"... (3 Replies)
Discussion started by: fongthai
3 Replies

3. UNIX for Advanced & Expert Users

Script to reformat output

Hi colleagues, I have the followind script. db2 -x "select substr(TBSPACE,1,20) TABLESPACE from syscat.tables where tabschema = 'SCHEMA' and tabname like '%XXXX' group by TBSPACE order by TBSPACE" | awk '{print $1}' | while read tablespace do db2 "list tablespaces show detail" |grep -p -w... (5 Replies)
Discussion started by: systemoper
5 Replies

4. Shell Programming and Scripting

need awk or sed help to reformat output

We have the following output: server1_J00_data_20120711122243 server1_J00_igs_20120711122243 server1_J00_j2ee_20120711122243 server1_J00_sec_20120711122243 server1_J00_data_20120711131819 server1_J00_igs_20120711131819 server1_J00_j2ee_20120711131819 server2_J00_data_20120711122245... (10 Replies)
Discussion started by: ux4me
10 Replies

5. Shell Programming and Scripting

awk to reformat text

I have this input and want output like below, how can I achieve that through awk: Input: CAT1 FRY-01 CAT1 FRY-04 CAT1 DRY-03 CAT1 FRY-02 CAT1 DRY-04 CAT2 FRY-03 CAT2 FRY-02 CAT2 DRY-01 FAT3 DRY-12 FAT3 FRY-06 Output: category CAT1 item FRY-01 (7 Replies)
Discussion started by: aydj
7 Replies

6. Shell Programming and Scripting

awk reformat file

Hello: When I tried a perl-oneliner to re-format fasta file. infile.fasta >YAL069W-1.334 Putative promoter CCACACCACACCCACACACC ACACCACACCCACACACACA ACAGCCCTAATCTAACCC >YAL068C-7235.2170 Putative ABC sequence TACGAGAATAATTT ACGTAAATGAAGTT TATATATAAA >gi|31044174|gb|AY143560.1|... (15 Replies)
Discussion started by: yifangt
15 Replies

7. Shell Programming and Scripting

Use search pattern to reformat the output

I have below file listing ] ls -1 *.txt MISTradesReport_141105_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-24.txt MISTradesReport_141106_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-24.txt MISTradesReport_141107_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-24.txt... (4 Replies)
Discussion started by: krg.sati
4 Replies

8. Shell Programming and Scripting

Using awk to reformat file output

Hi there. I need to reformat a large file. Here is a sample of the file. NETIK0102_UCS_Boot_a,NETIK0102_UCS_Boot_b 5200 2438 70G 5200 2439 70G NETIK0102_UCS_HBA0_a,NETIK0102_UCS_HBA1_b,NETIK0102_UCS_HBA2_a,NETIK0102_UCS_HBA3_b 2673 19D7 55G 2673 19C0 30G 2673 19F5 120G... (5 Replies)
Discussion started by: kieranfoley
5 Replies

9. Shell Programming and Scripting

Alter awk script to reformat output

Data: 0,mfrh_green_screen,1455432969,37540,/prod/test/system/sys/unikixmain.log,3.0M,mfrh_green_screen,3120660,0,36964--37540 0,mfrh_green_screen,1455433269,38100,/prod/test/system/sys/unikixmain.log,3.1M,mfrh_green_screen,3164223,0,37540--38100... (1 Reply)
Discussion started by: SkySmart
1 Replies

10. Shell Programming and Scripting

awk to reformat output if input file is empty, but not if file has data in it

The below awk improved bu @MadeInGermany, works great as long as the input file has data in it in the below format: input chrX 25031028 25031925 chrX:25031028-25031925 ARX 631 18 chrX 25031028 25031925 chrX:25031028-25031925 ARX 632 14... (3 Replies)
Discussion started by: cmccabe
3 Replies
All times are GMT -4. The time now is 01:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy