5

Transpose whole file and specific columns

view full story
linux-howto

http://www.unix.com – Hi, I have a file like this Code: a b c d e f g h i j k l Case1: I want to transpose the whole file Output1 Code: a d g j b e h k c f i l Case2 Transpose a specific column - Say 3rd Output2 Code: c f i l Case3 Transpose a range of columns - say 1 and 2 Output3 Code: a d g j b e h k Case4 Transpose specific multiple columns - say 1 and 3 Output Code: a d g j c f i l Initally, I was helped in this forum for transposing a single column of this kind input Code: a b c d using Code: tr '\n' ',' < input.txt Outpu (HowTos)

ziyi's picture
Submitted by ziyi on 07/17/2012 – Made popular on 07/17/2012

Stories similar to Transpose whole file and specific columns

Hi all!

I have this kind of output:

Code: a1|b1|c1|d1|e1 a2|b2|c2 a3|b3|c3|d3 I would like to transpose columns d and e (when they exist) in column c, and under the row where they come from. Then copying the beginning of the row.

In order to obtain:

Code: a1|b1|c1 a1|b1|d1 a1|b1|e1 a2|b2|c2 a3|b3|c3 a3|b3|d3 I have no idea how to do that ...

If someone could help me, it would be gre

awk multiple delimiters 37 weeks 1 day ago

Hi Folks,

This is the first time I ever encountered this situation

My input file is of this kind

cat input.txt

Code: 1 PAIXAF 0 1 1 -9 0 0 0 1 2 0 2 1 2 1 7 PAIXEM 0 7 1 -9 1 0 2 0 1 2 2 1 0 2 9 PAKZXY 0 2 1 -9 2 0 1 1 1 0 1 2 0 1 Till the sixth column (which is -9), I want my columns to be in the same way as the input.

After the sixth column, I want to merge every two columns till the

Hi Experts,

Can you please help me in transposing Datefield from rows to column and calculate the time difference for each of the Jobids:

Input File:

Code: 08/23/2012 12:36:09,JOB_5340 08/23/2012 12:36:14,JOB_5340 08/23/2012 12:36:22,JOB_5350 08/23/2012 12:36:26,JOB_5350 Required Output:

Code: 08/23/2012 12:36:14,08/23/2012 12:36:09,00:00:05,JOB_5340 08/23/2012 12:36:26,08/2

sort second columns in file. 1 year 13 weeks ago

File will have two columns key column and second column which is pipe separated and that need to be sorted.

Below is input file.

Code:

1, D|B|A|C 2, C|A|B 3, E|A|F|G|H|D|B|C 4, A|B|D|C|F Output should be

Code:

1, A|B|C|D 2, A|B|C 3, A|B|C|D|E|F|G|H 4, A|B|D|C|F Thanks in advance and I appreciate your help

Hi friends,

I have one file like below.

Hi,

I have a tab delimited text file with multiple columns. The second and third columns include numbers that have not been sorted. I want to extract rows where the second column includes a value between -0.01 and 0.01 (including both numbers) and the first third column includes a value between 1 and 5 (including). How do I go about doing that?

Help with ask adding columns 24 weeks 1 day ago

Hello,

I am using AWK in UBUNTU 12.04.

I have a dataset as follows:

Code: 1 2 12 1 4 1 4 1 7 9 4 6 1 2 4 5 7 8 45 7 4 5 7 5 What I want to do is to add the values of some columns to each other and print it in the same file as the new column while omitting the previous two columns to have output as follows as an example:

1+4+4=9 2+1+6=9

So:

Code: 9 9 12 1 4 1 7 9 53 14 4 5 7 8 4

Hello Expert,

I need to transpose Date-Timestamp based on same column values and calculate time difference.

Hello,

I have a very large file for which I would like to remove all rows for which the value of columns 2-5 is zero.