|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to convert columns to rows | suresh3566 | Shell Programming and Scripting | 6 | 11-04-2008 08:20 AM |
| merge rows based on a common column | smriti_shridhar | Shell Programming and Scripting | 6 | 10-17-2008 07:15 AM |
| awk - reformating rows into columns | jmd2004 | Shell Programming and Scripting | 1 | 08-14-2008 12:56 AM |
| Columns to rows | mgirinath | Shell Programming and Scripting | 16 | 11-29-2007 07:03 PM |
| Compare two files and merge columns in a third | CM64 | Shell Programming and Scripting | 20 | 04-04-2007 02:41 PM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
01-16-2009
|
||||
|
||||
How to merge rows into columns ????
Hi guz I want to merge multiple rows into a multiple columns based on the first column.
The file has symbol // I want to break the symbool // and I nedd exactlynew column at that point the output will be like this please guyz help in this isssue!!!!! merging rows into columns FIle1 a 1 b 2 c 3 d 4 // a 9 b 44 // c 5 d 8 c 4 d 0 Output a b c d 1 2 3 4 9 44 5 8 4 0 |
|
01-16-2009
|
||||
|
||||
|
Hi
I have a file with 2 columns. evry set in a column ends with a symbol //.
the first one with something like chr, chr no, chromosome name, cell no. cell no. etc and the second column has values belong to the first columnlike chr Xy, 22, 345,22222 etc. Some clumns have repeated but not duplicate values. with these I want to make file with first cloumn as first row and second olumn as second row and so on... chr chrXY chr no 22 chrname FUUR Cell 224Neuron Cell no 22222 // chr chrYY chr no 23 chrname FUUS Cell 225Neuron Cell no 22223 // chr chrYY chr no 24 chrname FUUT Cell 226Neuron Cell no 22222 Cell 227Neuron Cell no 222245 Cell 230Neuron Cell no 22245 // chr chrYY chr no 25 chrname RUUS Cell 225Neuron Cell no 52223 chr chr no chrname Cell Cell no chrXY 22 FUUR 224Neuron 22222 chrYY 23 FUUS 225Neuron 22223 chrYY 24 FUUT 226Neuron 222222 227Neuron 222245 230Neuron 22245 chrYY 25 RUUS 225Neuron 52223 |
|
01-16-2009
|
||||
|
||||
|
Output chr .........chr no....... chrname ......Cell............. Cell no chrXY....... 22 ............FUUR .........224Neuron..... 22222 chrYY .......23 .............FUUS .........225Neuron .....22223 chrYY....... 24 .............FUUT.......... 226Neuron.... 222222 ...................................................227Neuron.... 222245 ..................................................230Neuron ......22245 chrYY .......25............. RUUS ..........225Neuron ......52223 |
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
