Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Sorting rows to columns

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Sorting rows to columns
# 1  
Old 03-13-2013
Sorting rows to columns
Dear all,
I need your help to sort out a file with more then 15, 000 rows,

input file has following format :
Code:
 AT4560 GO:1289GO:8915GO:9243GO:5739GO:6757GO:9245GO:9507

output should be like:
Code:
AT4560  GO:1289
AT4560  GO:8915
AT4560  GO:9243
AT4560  GO:5739
AT4560  GO:6757
AT4560  GO:9245
AT4560  GO:9507

thanks in advance for help
Regards
# 2  
Old 03-13-2013
With some assumptions..

Code:
$ awk '{for(i=1;i<=length($2);i+=7){print $1,substr($2,i,7)}}' file

AT4560 GO:1289
AT4560 GO:8915
AT4560 GO:9243
AT4560 GO:5739
AT4560 GO:6757
AT4560 GO:9245
AT4560 GO:9507

# 3  
Old 03-13-2013
Hi Pamu,
I gave this command in cygwin,
Code:
 awk '{for(i=1;i<=length($2);i+=7){print $1,substr($2,i,7)}}'AT.txt > ATTT.txt

and got, SYNTEX ERROR line 1

waiting for help

Regards
# 4  
Old 03-13-2013
Quote:
Originally Posted by AAWT
Hi Pamu,
I gave this command in cygwin,
Code:
 awk '{for(i=1;i<=length($2);i+=7){print $1,substr($2,i,7)}}'AT.txt > ATTT.txt

and got, SYNTEX ERROR line 1

waiting for help

Regards
Please give space between awk and filename.

try with..

Code:
awk '{for(i=1;i<=length($2);i+=7){print $1,substr($2,i,7)}}' AT.txt > ATTT.txt

This User Gave Thanks to pamu For This Post:
AAWT
# 5  
Old 03-13-2013
pamu's proposal works fine if there's always four digit numbers. Should that change, and should "GO" stay the substring where to split the line,try:
Code:
$ awk '{gsub (/GO/, FS"GO");for (i=2; i<=NF; i++) print $1, $i}' file
AT4560 GO:1289
AT4560 GO:8915
etc...

This User Gave Thanks to RudiC For This Post:
AAWT
# 6  
Old 03-13-2013
thanks Pamu,
thanks RudiC, its also work fine,
yes, its exactly what I need,Smilie
thanks a lot
Regards
Last edited by AAWT; 03-13-2013 at 10:23 AM..
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies

2. Shell Programming and Scripting

Sorting by columns

Hi, I have a tab delimited columnar file where I want to remove lines wherever two particular columns match. so for this file, I want to toss the lines where columns 1 and 2 match: a a 1 3 a b 2 4 b b 3 5 because there are matches column 1 and 2 in lines 1 and 3, I would like a script to... (2 Replies)
Discussion started by: mikey11415
2 Replies

3. Shell Programming and Scripting

Evaluate 2 columns, add sum IF two columns match on two rows

Hi all, I know this sounds suspiciously like a homework course; but, it is not. My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Discussion started by: mtucker6784
6 Replies

4. Shell Programming and Scripting

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

Hi Friends, I have come across some files where some of the columns don not have data. Key, Data1,Data2,Data3,Data4,Data5 A,5,6,,10,, A,3,4,,3,, B,1,,4,5,, B,2,,3,4,, If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies

5. Shell Programming and Scripting

Kindly Help regarding sorting a file rows

Dear All, I have a file name exporting.txt. Below is the content. $ cat exporting.txt . . exporting table DT_BCD 63716 rows exported . . exporting table DT_CVD 36321 ... (2 Replies)
Discussion started by: sudiptabhaskar
2 Replies

6. Shell Programming and Scripting

Help in sorting multiple columns

Hello all, I am using printf to print the sorted o/p in my script.I am trying to sort in following way but doesn't work. printf "%13s %2s UDP %15s:%s Program %4s HD: %23s HD: %23s %10s %s %s %3s days %3s hours\n" $encoder $i "${ipaddr}" ${portno} ${progno} ${inres} ${outres} ${inrate}... (4 Replies)
Discussion started by: ramman
4 Replies

7. Shell Programming and Scripting

sorting and adding columns

i have a file with two columns, and i want to uniquely sort the values in fist column and add the corresponding values in the second columns eg file a contents tom 200 john 300 sow 500 tom 800 james 50 sow 300 output shpould be in file b as tom 1000 john 300 sow 800 james 50 (0 Replies)
Discussion started by: dealerso
0 Replies

8. UNIX for Dummies Questions & Answers

Vertical sorting of columns

Please help to sort columns in this file: a b d f c e 1 4 10 16 7 13 2 5 11 17 8 14 3 6 12 18 9 15 I need to sort COLUMNS (so sort command doesn't work) like this: a b c d e f 1 4 7 10 13 16 2 5 8 11 14 17 3 6 9 12 15 18 I know sed can do it but don't know how... :( (7 Replies)
Discussion started by: coppuca
7 Replies

9. UNIX for Advanced & Expert Users

sorting of varchar columns

Hi , I need to sort a file based on multiple columns All the columns are of varchar type can any one give me the command to sort for varchar columns? Thanks (3 Replies)
Discussion started by: laxmi131
3 Replies

10. Shell Programming and Scripting

Sorting based on columns

Hi, I want a list of entries in 3 space delimited columns. I want to sort entries based on the very first column. Rows can't be changed. For example: If I have... Abc Abc Acc Bca Bda Bdd Cab Cab Cbc Dbc Dca Dda Abc Abc Acc the output should be... Abc Abc Acc Abc Abc Acc Bca... (7 Replies)
Discussion started by: MobileUser
7 Replies
Login or Register to Ask a Question