Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk transpose column to row and sort

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk transpose column to row and sort
# 1  
Old 04-17-2014
awk transpose column to row and sort
I am trying to awk the output from below output for each port: i need separate line with comma

source file

Quote:
port: 1
stat_mc_to 0 Multicast timeouts
tim_txcrd_z 346863586 Time TX Credit Zero (2.5Us ticks)
tim_txcrd_z_vc 0- 3: 153934154 0 15718642 91748229
tim_txcrd_z_vc 4- 7: 24761659 60700902 0 0
tim_txcrd_z_vc 8-11: 0 0 0 0
tim_txcrd_z_vc 12-15: 0 0 0 0
er_bad_os 0 Invalid ordered set
er_rx_c3_timeout 593 Class 3 receive frames discarded due to timeout
er_tx_c3_timeout 0 Class 3 transmit frames discarded due to timeout
port: 2
stat_mc_to 0 Multicast timeouts
tim_txcrd_z 0 Time TX Credit Zero (2.5Us ticks)
tim_txcrd_z_vc 0- 3: 0 0 0 0
tim_txcrd_z_vc 4- 7: 0 0 0 0
tim_txcrd_z_vc 8-11: 0 0 0 0
tim_txcrd_z_vc 12-15: 0 0 0 0
er_bad_os 1633587140 Invalid ordered set
er_rx_c3_timeout 0 Class 3 receive frames discarded due to timeout
er_tx_c3_timeout 0 Class 3 transmit frames discarded due to timeout
Output required

Quote:
port: 1,stat_mc_to 0 Multicast timeouts,tim_txcrd_z 346863586 Time TX Credit Zero (2.5Us ticks),tim_txcrd_z_vc 0- 3: 153934154 0 15718642 91748229,tim_txcrd_z_vc 4- 7: 24761659 60700902 0 0,tim_txcrd_z_vc 8-11: 0 0 0 0,tim_txcrd_z_vc 12-15: 0 0 0 0,er_bad_os 0 Invalid ordered set,er_rx_c3_timeout 593 Class 3 receive frames discarded due to timeout,er_tx_c3_timeout 0 Class 3 transmit frames discarded due to timeout
port: 2,stat_mc_to 0 Multicast timeouts,tim_txcrd_z 0 Time TX Credit Zero (2.5Us ticks),tim_txcrd_z_vc 0- 3: 0 0 0 0,tim_txcrd_z_vc 4- 7: 0 0 0 0,tim_txcrd_z_vc 8-11: 0 0 0 0,tim_txcrd_z_vc 12-15: 0 0 0 0,er_bad_os 1633587140 Invalid ordered set,er_rx_c3_timeout 0 Class 3 receive frames discarded due to timeout,er_tx_c3_timeout 0 Class 3 transmit frames discarded due to timeout
# 2  
Old 04-17-2014
Code:
awk '{if($0 ~ /^port: [0-9]*$/ && NR > 1) print "\n" $0; else print}' file | awk '{out = $1; for(i = 2; i<= NF; i++) {out = (out "," $i)}; print out}' FS='\n' RS=

# 3  
Old 04-17-2014
Code:
paste -d, - - - - - - - - - - < file

# 4  
Old 04-21-2014
thanks for the support i can able to resolve this by using this.

Quote:
awk 'ORS=(NR%10==0)?"\n":","'
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Transpose the Row and column

Hi, I have data in form of A ram B shyam C seeta D geeta A bob B methew C Richad D Mike and i want it in this form. A B C D ram shyam seeta geeta bob methew Richard Mike. please help by providing the scripting for this. (3 Replies)
Discussion started by: ricbha
3 Replies

2. Shell Programming and Scripting

How transpose column in a row?

Hello guys, First of all happy holidays and happy new year. I'm new in bioinformatic and also it is my first time that I write in this forum. Therefore, sorry if I make some mistakes. I'm writing to ask your help to fix a problem: I have a file like this: gene1 GO:0016491|GO:0055114... (8 Replies)
Discussion started by: Salvatore_espos
8 Replies

3. Shell Programming and Scripting

Transpose row to column

I'm using the testawk.awk from the following thread https://www.unix.com/shell-programming-and-scripting/18897-row-column-transpose.htmlI'm getting the following output fieldname1 data1 fieldname2 data2 fieldname3 data3 How can I get like this instead 1 fieldname1 data1 2 fieldname2 data2... (1 Reply)
Discussion started by: makkan
1 Replies

4. Shell Programming and Scripting

Transpose column to row - awk

Hi there, I have a small csv file example below: source,cu_001,cu_001_volume,cu_001_mass,cu_002,cu_002_volume,cu_002_mass,cu_003,cu_003_volume,cu_003_mass ja116,1.33,3024000,9374400,1.54,3026200,9375123,1.98,3028000,9385512 I want to transpose columns to rows starting at the second... (3 Replies)
Discussion started by: theflamingmoe
3 Replies

5. UNIX for Dummies Questions & Answers

Row to column transpose

Hi there, Below is sample three rows which i need transpose into multiple rows. By keeping first 2 fields static and split them into multiple rows depend following date field. Each into seperate rows. Sample code: ... (6 Replies)
Discussion started by: ganeshd
6 Replies

6. Shell Programming and Scripting

awk to transpose preceding row to 1st column of next rows

Gurus: How can I transpose the output below to a format in which I can plot a graph to show VSZ memory usage by PIDs? stdout: Tue Jan 22 07:29:19 CUT 2013 42336296 1841272 java wilyadm 21889232 438616 jlaunch sidadm 42532994 414336 jlaunch sidadm Tue Jan 22 07:49:20 CUT 2013... (1 Reply)
Discussion started by: ux4me
1 Replies

7. Shell Programming and Scripting

awk transpose row into 2 field column

Need to transpose every 2 fields of a row into a single 2 field column. input 4 135 114 76 217 30 346 110 5 185 115 45 218 85 347 125 6 85 116 130 220 65 352 95 11 30 117 55 221 42 355 75 16 72 118 55 224 37 357 430 17 30 119 55 225 40 358 62 21 52 120 65 232 480 360 180 ....... (8 Replies)
Discussion started by: sdf
8 Replies

8. Shell Programming and Scripting

awk: Transpose csv row to column.

Hello, am I new to awk, and I am tryint to: INPUT FILE: "73423555","73423556","73423557","73423558","73423559" OUTPUT FILE: 73423555 73423556 73423557 73423558 73423559 My useless code so far: #!/bin/awk -F ',' BEGIN { i=0; } (8 Replies)
Discussion started by: drbiloukos
8 Replies

9. Shell Programming and Scripting

Transpose column to row

Hi i have a file which has values seperated by "," as shown below and I want to transpose for every doc_id in one row. Input: DOC_ID,KEYWORD 105,REGISTROS 105,GEOLOGIA 105,NUCLEOS 105,EXPEDIENTE 105,PROGRAMAS 10025,EXPEDIENTE 10025,LOCALIZACIONES 10025,OFICIOS 10025,PROGRAMAS... (4 Replies)
Discussion started by: juelillo
4 Replies

10. Shell Programming and Scripting

Row to column transpose

Can we transpose rows to columns? Fields within row are separated by a comma. (10 Replies)
Discussion started by: videsh77
10 Replies
Login or Register to Ask a Question