Sponsored Content
Top Forums Shell Programming and Scripting Transpose the 2nd coloumn in every fourth row three times.... Post 303029316 by bertbrutzel on Thursday 24th of January 2019 04:22:32 PM
Old 01-24-2019
Transpose the 2nd coloumn in every fourth row three times....

I have several csv files, each hundreds of rows with the following layout

Code:
"","SEQ ID No.  1 Subject # 20"
"BPM neg.:",68.83
"BPM normal:",68.48
"SEQ ID No.  1 Subject # 20",79.33
"","SEQ ID No.  10 Subject # 20"
"BPM neg.:",68.05
"BPM normal:",68.58
"SEQ ID No.  10 Subject # 20",81.63
"","SEQ ID No.  17 Subject # 20"
"BPM neg.:",71.06
"BPM normal:",71.19
"SEQ ID No.  17 Subject # 20",81.99

I would need the first and fifth and ninth and.... row be transposed into a third coloumn three times giving me this output:


Code:
"BPM neg.:",68.83"","SEQ ID No.  1 Subject # 20"
"BPM normal:",68.48"","SEQ ID No.  1 Subject # 20"
"SEQ ID No.  1 Subject # 20",79.33"","SEQ ID No.  1 Subject # 20"
"BPM neg.:",68.05"","SEQ ID No.  10 Subject # 20"
"BPM normal:",68.58"","SEQ ID No.  10 Subject # 20"
"SEQ ID No.  10 Subject # 20",81.63"","SEQ ID No.  10 Subject # 20"
"BPM neg.:",71.06"","SEQ ID No.  17 Subject # 20"
"BPM normal:",71.19"","SEQ ID No.  17 Subject # 20"
"SEQ ID No.  17 Subject # 20",81.99"","SEQ ID No.  17 Subject # 20"

Many thanks,....

Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!

Last edited by RudiC; 01-24-2019 at 05:56 PM.. Reason: Added CODE tags.
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. UNIX for Dummies Questions & Answers

transponse row to coloumn output

dears i have row data as below: ======================================================================================== Session Count: 24580 Session Count: 13426 Session Count: 22533 Session Count: 0 Session Count: 0 Session Count: 15036 Session Count: 11625 Session Count: 6942... (3 Replies)
Discussion started by: thehero
3 Replies

4. UNIX for Dummies Questions & Answers

Select 2 columns and transpose row by row

Hi, I have a tab-delimited file as follows: 1 1 2 2 3 3 4 4 a a b b c c d d 5 5 6 6 7 7 8 8 e e f f g g h h 9 9 10 10 11 11 12 12 i i j j k k l l 13 13 14 14 15 15 16 16 m m n n o o p p The output I need is: 1 1 a a 5 5 e e 9 9 i i 13... (5 Replies)
Discussion started by: mvaishnav
5 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

Column to row Transpose

Hi Folks, Iam a kinda newbie to unix shell scripting, the scenario is i have a text file containing the following info Charlie chicago 15 Charlie newyork 26 jonny chicago 14 jonny newyork 15 joe chicago 15 joe newyork 18output should be Name chicago ... (3 Replies)
Discussion started by: tech_frk
3 Replies

7. Shell Programming and Scripting

To transpose row into column

Hi All, In shell, I have below data coming from some some text file as below: . 351706 5861.8 0.026 0.012 12.584 0.026 0.012 12.582 0.000 0.000 0.000 Now i need the above data to be transposed as below 351706... (16 Replies)
Discussion started by: Anamica
16 Replies

8. 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

9. Shell Programming and Scripting

Transpose columns to row

Gents Using the attached file and using this code. awk '{print substr($0,4,2)}' input.txt | sort -k1n | awk '{a++}END{for(i in a) print i,a}' | sort -k1 > output i got the this output. 00 739 01 807 02 840 03 735 04 782 05 850 06 754 07 295 08 388 09 670 10 669 11 762 (8 Replies)
Discussion started by: jiam912
8 Replies

10. 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
NG_FEC(4)						   BSD Kernel Interfaces Manual 						 NG_FEC(4)

NAME
ng_fec -- netgraph Fast EtherChannel node SYNOPSIS
#include <netgraph/ng_fec.h> DESCRIPTION
The fec node implements Ethernet port trunking using the ``Cisco Fast EtherChannel'' protocol. Upon creation, a fec node creates a network interface associated with it. Interfaces are named ``fec0'', ``fec1'', etc. New nodes take the first available unit. HOOKS
The fec node accepts any hooks. However it does not use them. Under normal operation, a fec node should not have any hooks. CONTROL MESSAGES
Interface membership in the FEC group is configured with the following control messages: NGM_FEC_ADD_IFACE (``add_iface'') Attach interface to the FEC group. The target interface name is passed as a string argument. NGM_FEC_DEL_IFACE (``del_iface'') Remove interface from the trunk. The target interface name is passed as a string argument. The following control messages define the forwarding method for a node: NGM_FEC_SET_MODE_MAC (``set_mode_mac'') Forwarding decisions will be based on the link-layer MAC address of the destination. NGM_FEC_SET_MODE_INET (``set_mode_inet'') Forwarding decisions will be based on the IP address of the destination. SHUTDOWN
This node shuts down upon receipt of a NGM_SHUTDOWN control message. EXAMPLES
The following example script creates an fec node, attaches four Ethernet interfaces to it and sets the forwarding method to be IP-address based: /usr/sbin/ngctl -f- << SEQ mkpeer fec dummy fec msg fec0: add_iface "dc0" msg fec0: add_iface "dc1" msg fec0: add_iface "dc2" msg fec0: add_iface "dc3" msg fec0: set_mode_inet SEQ SEE ALSO
netgraph(4) HISTORY
The fec node type was implemented in FreeBSD 5.0. AUTHORS
The fec node was written by Bill Paul <wpaul@FreeBSD.org>. This manual page was written by Gleb Smirnoff <glebius@FreeBSD.org>. BSD
July 22, 2004 BSD
All times are GMT -4. The time now is 06:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy