Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
 |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| split the fields in a column into 3 columns | rakshit | Web Programming, Web 2.0 and Mashups | 2 | 03-06-2009 04:44 AM |
| Combine multiple columns from multiple files | martva | Shell Programming and Scripting | 5 | 12-02-2008 09:23 AM |
| Single column to multiple columns in awk | astroDave | Shell Programming and Scripting | 2 | 03-27-2008 10:00 PM |
| How to check Null values in a file column by column if columns are Not NULLs | Mandab | Shell Programming and Scripting | 7 | 03-15-2008 09:57 AM |
| single column to multiple columns | agibbs | UNIX for Dummies Questions & Answers | 7 | 12-05-2007 10:04 PM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
06-29-2009
|
||||
|
||||
|
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. Any help please? Thanx  |
|
06-29-2009
|
||||
|
||||
|
Try...
Code:
awk '{a[NR%3+1]=a[NR%3+1]" "$0} END {for (i in a){print a[i]}}' inputfile
|
|
06-29-2009
|
||||
|
||||
|
Thanx, That almost worked...
But the output to your code yields: 3 6 9 1 4 7 2 5 8 So i just fiddled with it a bit and came up with 1 4 7 2 5 8 3 6 9 using awk '{a[NR%2+2]=a[NR%3+1]" "$0} END {for (i in a){print a[i]}}' inputfile, but i hav one open line at the beginning of the file ---------- Post updated at 07:47 AM ---------- Previous update was at 07:39 AM ---------- if i apply this to: 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 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 0.000000 0.000000 0.000000 4.600000 9.800000 12.70000 12.90000 33.80000 i lose the ascending order in the 3rd column... y is this and how can i fix it? 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 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 4.600000 0.000000 0.000000 9.800000 0.000000 0.000000 12.70000 0.000000 0.000000 33.80000 0.000000 0.000000 12.90000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 |
|
06-29-2009
|
|||||
|
|||||
|
Homework is not permitted at The UNIX and Linux Forums.
Please read the rules, which you agreed to when you registered, if you have not already done so. More-than-likely, posting homework has resulting in a forum infraction. If you did not post homework, please explain the company you work for and the nature of the problem you are working on. Thank You. The UNIX and Linux Forums. |
| Sponsored Links | ||
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
