How to convert a single column into several columns?

Login or Register to Ask a Question and Join Our Community

How to convert a single column into several columns?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to convert a single column into several columns?

06-06-2011

Registered User

60, 0

Join Date: Jul 2007

Last Activity: 18 December 2011, 2:24 PM EST

Posts: 60

Thanks Given: 11

Thanked 0 Times in 0 Posts

How to convert a single column into several columns?

Hi

I have a ksh script which gives me the output as a single column with several rows like:

AAA
BBB
CCC
DDD
EEE
FFF
GGG
HHH
III

I want to be able to create a new file from this file which allows me to set the number of rows and columns in the new file, i.e. for this example, if I specify 3 rows and 3 columns, the output should look like

file.txt:

AAA DDD GGG
BBB EEE HHH
CCC FFF III

Is it possible to do this in Unix using sed command and in comma separated?

I tried

cat file.txt | sed 'N;N;s/\n/,/g'

but its giving me wrong output.

Thank You,
Pinpe

pinpe

View Public Profile for pinpe

Find all posts by pinpe

06-06-2011

Registered User

353, 50

Join Date: Jul 2008

Last Activity: 15 March 2015, 2:47 AM EDT

Location: India

Posts: 353

Thanks Given: 9

Thanked 50 Times in 49 Posts

Try this.

Code:

cgi@tioman> (/home/cgi) $ awk -v col=3 '{if(NR%col){printf "%s ",$0 }else {printf "%s\n",$0}} ' test.txt
AA BBB CCC
DDD EEE FFF
GGG HHH III
cgi@tioman> (/home/cgi) $

But i think you can set any one rows / columns and the other goes depends on your file size.

kumaran_5555

View Public Profile for kumaran_5555

Find all posts by kumaran_5555

06-06-2011

Registered User

124, 29

Join Date: May 2011

Last Activity: 16 July 2018, 1:31 AM EDT

Location: India

Posts: 124

Thanks Given: 2

Thanked 29 Times in 29 Posts

Code:

perl -0ane 'BEGIN{$cols=3}END{for($i=0;$i<=$#F;$i++){print "$F[$i]\t"; print "\n" if((($i+1) % $cols) == 0)}}' inp

Her I have given the cols a 3. You can change it as per ur req

getmmg

View Public Profile for getmmg

Find all posts by getmmg

06-06-2011

Registered User

60, 0

Join Date: Jul 2007

Last Activity: 18 December 2011, 2:24 PM EST

Posts: 60

Thanks Given: 11

Thanked 0 Times in 0 Posts

Hi getmmg/kumaran_5555,

Thanks for the prompt response but..

My desired output should be like this...

AAA DDD GGG
BBB EEE HHH
CCC FFF III

Your script output is this...

AAA BBB CCC
DDD EEE FFF
GGG HHH III

Br,
Pete

pinpe

View Public Profile for pinpe

Find all posts by pinpe

06-06-2011

Registered User

320, 81

Join Date: Aug 2009

Last Activity: 14 May 2019, 11:07 AM EDT

Location: France

Posts: 320

Thanks Given: 19

Thanked 81 Times in 76 Posts

Using Awk

Code:

awk '{A[(NR-1)%3]=A[(NR-1)%3]$0" ";next}END{for(i in A)print A[i]}' your_infile

Last edited by tukuyomi; 06-06-2011 at 08:11 AM..

tukuyomi

View Public Profile for tukuyomi

Find all posts by tukuyomi

06-06-2011

Registered User

353, 50

Join Date: Jul 2008

Last Activity: 15 March 2015, 2:47 AM EDT

Location: India

Posts: 353

Thanks Given: 9

Thanked 50 Times in 49 Posts

We all missed that. :-)
Try this one, again you have freedom to choose only the rows. This works on linux.

Code:

cgi@tioman> (/home/cgi) $ awk -v row=3 '{arr[NR%row]=arr[NR%row]" "$0} END{n=asort(arr);for(i=1;i<=n;i++){print arr[i]}} ' test.txt
 AA DDD GGG
 BBB EEE HHH
 CCC FFF III

kumaran_5555

View Public Profile for kumaran_5555

Find all posts by kumaran_5555

06-06-2011

Registered User

124, 29

Join Date: May 2011

Last Activity: 16 July 2018, 1:31 AM EDT

Location: India

Posts: 124

Thanks Given: 2

Thanked 29 Times in 29 Posts

This should work

Code:

perl -lne 'BEGIN{$cols=3;$i=0}; $hash{$i}.= "$_ "; $i++; $i=0 if($i == $cols); END{print $_ for values %hash}' inp

getmmg

View Public Profile for getmmg

Find all posts by getmmg

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert row to columns start from nth column

Dear All, We have input like this: 161 57 1378 176 1392 262 1444 441 1548 538 1611 670 1684 241 57 1378 208 1393 269 1447 444 1549 538 1610 677 1700 321 ...

2. Shell Programming and Scripting

Convert single column into multiple rows

Convert Single column to multiple rows file a.txt contains data like below Server=abc Run=1 Tables=10 Sessions=16 Time=380 Jobs=5 Server=abc Run=2 Tables=15 Sessions=16 Time=400 Jobs=5 Server=abc Run=3 Tables=20 Sessions=16 Time=450

3. Shell Programming and Scripting

Multiple columns to a single column

I have this input: 10 22 1 100 11 22 10 1 50 14 3 1 100 23 3 1 100 24 15 1 100 10 22 5 3 1 33.333 11 22 1 100 It has an inconsistent number of fields but the last field is determined by 100/(NF-2) using awk. I want to take this multiple columned input file and transform so that...

4. Shell Programming and Scripting

convert columns into rows with respect to first column

Hello All, Please help me with this file. My input file (Tab separated) is like: Abc-01 pc1 -0.69 Abc-01 E2cR 0.459666666666667 Abc-01 5ez.2 1.2265625 Xyz-01 pc1 -0.153 Xyz-01 E2cR 1.7358 Xyz-01 5ez.2 2.0254 Ced-02 pc1 -0.5714 Ced-02 ...

5. Shell Programming and Scripting

Convert columns to single row

Hello all I have data like 1 2 3 4 5 I wish my output would be like 1,2,3,4,5 For this i have executed 'BEGIN {FS="\n"; ORS=","} {print $0}' test and got the output as 1,2,3,4,5, I do not want to have , at the end of 5. output should be like

6. Shell Programming and Scripting

how to introduce a space in a single column without distrubing the other columns

Hello Experts, I am new to this forum, I would like to do the following changes in one of the column of a txt file, which is having around 9 column. For example, column 3 is having letters like this AB11 AB12 C CA CB AC1 AC2 I would like to convert the same column as follows ...

7. Shell Programming and Scripting

Convert two column data into 8 columns

Apologies if this has been covered - I did search but couldn't find what I was looking for. I have a simple X-Y input file. I want to convert it from two columns into 8 columns - 4 pairs of X-Y data. So my input file looks like X1 Y1 X2 Y2 X3 Y3 X4 Y4 X5 Y5 etc And I want it to look...

8. UNIX for Dummies Questions & Answers

How to convert a single column into several rows and columns?

I have a program which gives me the output as a single column with hundreds of rows like: 213 314 324 324 123 I want to be able to create a new file from this file which allows me to set the number of rows and columns in the new file, i.e. for this example, if I specify 3 rows and 2...

9. Shell Programming and Scripting

Single column to multiple columns in awk

Hi - I'm new to the awk programming language. I'm trying to print a single column of data to several columns, and I found an article on iTWorld.com (ITworld.com - Printing in columns). It looks like the mkCols2 script is very close to what I need to do, but it looks like the end of the code...

10. UNIX for Dummies Questions & Answers

single column to multiple columns

Hello, I have a single column of data that I would like to cut/print (with awk or ...) into multiple columns at every empty row (or common character). Input: 5.99123 5.94693 7.21383 5.95202 0.907935 5.99149 6.08427 0.975774 6.077 Output: 5.99123 5.95202 6.08427 5.94693...

Login or Register to Ask a Question