Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Several columns to two column

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Several columns to two column
# 1  
Old 12-10-2012
Several columns to two column
Dear All,

I have file :
input.txt

Code:
HANDVEL 2201181                                                1000      180       
19      1540    173     1581    316     1652    509     1707    
653     1767    816     1834    951     1882    1100    1984    
1225    2050    1331    2109    1732    2491    1927    2665    
2237    2893    2351    2972    2563    3103    2785    3226    
3981    3900    
HANDVEL 2201189                                                1000      188       
24      1540    156     1580    295     1642    435     1679    
536     1695    641     1760    790     1811    906     1861    
1011    1935    1202    2039    1336    2116    1452    2225    
1766    2524    2180    2853    2308    2942    2998    3346    
3981    3901

Desired output,
output.txt

Code:
HANDVEL 2201181                                                1000      180       
19      1540    
173     1581    
316     1652    
509     1707    
653     1767    
816     1834    
951     1882    
1100    1984    
1225    2050    
1331    2109    
1732    2491    
1927    2665    
2237    2893    
2351    2972    
2563    3103    
2785    3226    
3981    3900    
HANDVEL 2201189                                                1000      188       
24      1540    
156     1580    
295     1642    
435     1679    
536     1695    
641     1760    
790     1811    
906     1861    
1011    1935    
1202    2039    
1336    2116    
1452    2225    
1766    2524    
2180    2853    
2308    2942    
2998    3346    
3981    3901

Any idea?

Thanks for advance,

Attila
# 2  
Old 12-10-2012
Code:
awk '/HANDVEL/{print;next}{for (i=1;i<=NF;i=i+2) print $i,$(i+1)}' infile

This User Gave Thanks to rdcwayx For This Post:
attila
# 3  
Old 12-10-2012
Code:
 
awk '/^[A-Z]/ {print $0} /^[0-9]/ { for (i=1;i<=NF;i=i+2) print $i,$(i+1) }' input.txt

Cheers,
Last edited by Joseph_TKLee; 12-10-2012 at 09:51 PM..
This User Gave Thanks to Joseph_TKLee For This Post:
attila
# 4  
Old 12-10-2012
It solved, thank you rdcwayx & Joseph_TKLee
# 5  
Old 12-11-2012
With Sed..
Code:
$ uname -rs
SunOS 5.10
$ sed -e '/HAND/!s/\([^ $]*  *[^ ]* *\)/\1\
> /g' -e 's/ *\n$//' inputfile

Similar fashion with awk..
Code:
nawk '/HAND/{print;next}{gsub(/[^ $]*  *[^ ]* */,"&\n");sub(/ *\n$/,"");print}' intputfile

Last edited by michaelrozar17; 12-11-2012 at 02:54 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to Sum columns when other column has duplicates and append one column value to another with Care

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For... (1 Reply)
Discussion started by: as7951
1 Replies

2. Shell Programming and Scripting

Combine columns from many files but keep them aligned in columns-shorter left column issue

Hello everyone, I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble. I have many files each having two columns and hundreds of rows. first column is a string (can have many words) and the second column is a number.The files are... (5 Replies)
Discussion started by: isildur1234
5 Replies

3. Shell Programming and Scripting

One Column To Two Columns

Having difficulty reformatting a 1 column file into a 2 column file as shown below: Example Input A 01 02 05 07 08 11 B 1193941 7231222 5192121 3221312 2211149 1783289 Required Output (13 Replies)
Discussion started by: bronofski
13 Replies

4. Shell Programming and Scripting

Splitting the data in a column into several columns

Hi, I have the following input file 32895901-d17f-414c-ac93-3e7e0f5ec240 AND @GDF_INPUT 73b129e1-1fa9-4c0d-b95b-4682e5389612 AUS @GDF_INPUT 40f82e88-d1ff-4ce2-9b8e-d827ddb39447 BEL @GDF_INPUT 36e9c3f1-042a-43a4-a80e-4a3bc2513d01 BGR @GDF_INPUT I want to split column 3 into two columns:... (1 Reply)
Discussion started by: ramky79
1 Replies

5. Shell Programming and Scripting

one column in different columns

I have a File with these format: A1 A2 A3 A4 B1 B2 B3 B4 . . . And I wont these format: A1 A2 A3 A4 B1 B2 B3 B4 .. .. .. .. .. ... How can I do that??? thanks (1 Reply)
Discussion started by: manudbc
1 Replies

6. Shell Programming and Scripting

Separating data from one column into two columns

Hello, I have a file that contains 64,235 columns and over 1000 rows and looks similar to this: ID dad mom 1 2 3 4 5.... 64232 1234 5678 6789 AA BB CC DD EE....ZZ 1342 5786 6897 BB CC DD EE FF....AA 1423 5867 6978 CC DD EE FF GG....BB I need to leave the first three columns in... (4 Replies)
Discussion started by: doobedoo
4 Replies

7. Shell Programming and Scripting

split one column into multiple columns

hey, i have the following data: 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 (7 Replies)
Discussion started by: zaneded
7 Replies

8. UNIX for Dummies Questions & Answers

split one column into multiple columns

hey guys... Im looking to do the following: 1 2 3 4 5 6 7 8 9 Change to: 1 4 7 2 5 8 3 6 9 Did use | perl -lpe'$\=$.%3?$":"\n"' , but it doesnt give me the matrix i want. (3 Replies)
Discussion started by: zaneded
3 Replies

9. Shell Programming and Scripting

How to check Null values in a file column by column if columns are Not NULLs

Hi All, I have a table with 10 columns. Some columns(2nd,4th,5th,7th,8th and 10th) are Not Null columns. I'll get a tab-delimited file and want to check col by col and generate seperate error code for each col eg:102 if 2nd col value is NULL and 104 if 4th col value is NULL so on... I am a... (7 Replies)
Discussion started by: Mandab
7 Replies

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... (7 Replies)
Discussion started by: agibbs
7 Replies
Login or Register to Ask a Question