Sorting HELP


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sorting HELP
# 1  
Old 08-12-2010
Sorting HELP

Hi, I have posted related topic but as i continue the research I find more need to sort the data.
Code:
AS(2607:f278:4101:11:dead:beef:f00f:f), AS786 AS6453 AS7575 AS7922    
AS(2607:f2e0:f:1db::16), AS786 AS3257 AS36252     
AS786 AS3257 AS36252      
AS(2607:f2f8:1700::2), AS786 AS6939 AS25795     
AS(2607:f388:e:0:218:8bff:fe23:786d), AS786 AS20965      
AS(2607:f4e8:12:fffe:230:48ff:fe96:f99e), AS786 AS3257      
AS(2607:f558:1000:f::42), AS786 AS20965      
AS(2607:f590:0:ffff::f1), AS786 AS6453      
AS(2001:1900:4:1::95) AS(2607:f728::), AS786 AS3356 AS6453 AS30496   
AS(2607:f740:0:d::2), AS786 AS6939

Please I need help in sorting the above data to output only the IPs and each corresponding ASnumber on each line(bearing in mind that some IPs have longer AS number than each other), like this;
Code:
2001:1900:4:1::95 AS786 AS3356 AS6453 AS30496
2607:f740:0:d::2 AS786 AS6939

Thanks a lot for your anticipated help

Last edited by Franklin52; 08-12-2010 at 01:13 PM.. Reason: Please use code tags
# 2  
Old 08-12-2010
What is the final expected output from the above sample?
# 3  
Old 08-12-2010
The. Outcome are the others lIsted below the first set.thanks
# 4  
Old 08-15-2010
Please, am still waiting for your help .thanks
# 5  
Old 08-15-2010
Not sure, if I understand your request.

Code:
awk -F[\(\),] '/\(/{split($2,a,":");b[a[1]]=$2 $NF}END {for (i in b) print b[i]}' urfile

# 6  
Old 08-16-2010
Hi, I think you must have mistaken my request please; These are the format of what I need to be sorted (its a long list but these are just few lines from the list);
AS(2607:f278:4101:11:dead:beef:f00f:f), AS786 AS6453 AS7575 AS7922
AS(2607:f2e0:f:1db::16), AS786 AS3257 AS36252
AS786 AS3257 AS36252
AS(2607:f2f8:1700::2), AS786 AS6939 AS25795
AS(2607:f388:e:0:218:8bff:fe23:786d), AS786 AS20965
AS(2607:f4e8:12:fffe:230:48ff:fe96:f99e), AS786 AS3257
AS(2607:f558:1000:f::42), AS786 AS20965
AS(2607:f590:0:ffff::f1), AS786 AS6453
AS(2001:1900:4:1::95) AS(2607:f728:Smilie, AS786 AS3356 AS6453 AS30496
AS(2607:f740:0:d::2), AS786 AS6939

Then, I want the output to be in the format for all of the above;
2607:f278:4101:11:dead:beef:f00f:f AS786 AS6453 AS7575 AS7922
2607:f2e0:f:1db::16 AS786 AS3257 AS36252
AS786 AS3257 AS36252
2607:f2f8:1700::2 AS786 AS6939 AS25795
2607:f388:e:0:218:8bff:fe23:786d AS786 AS20965
2607:f4e8:12:fffe:230:48ff:fe96:f99e AS786 AS3257
2607:f558:1000:f::42 AS786 AS20965
2607:f590:0:ffff::f1 AS786 AS6453
2001:1900:4:1::95 AS786 AS3356 AS6453 AS30496
2607:f740:0:d::2 AS786 AS6939

Thanks you.
# 7  
Old 08-16-2010
Code:
awk -F , '{if (NF==1) {print $0} else {gsub(/AS\(/,"");gsub(/\)/,"");split($1,a," ");print a[1],$2}}' urfile

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sorting

Hii guys, I need to sort my file and remove duplicates before writing to another file. The first line in the file are column names. I dont want this line to be sorted and should always be the first line in the output. sort -u file.txt > file1.txt. is the command that i am using... (4 Replies)
Discussion started by: just4u_sharath
4 Replies

2. Shell Programming and Scripting

sorting help

Hi, Please i need help in writing an 'awk' script in sorting the following data; traceroute6 to 2001:1ba0:2a0:5965:0:30:24:1 (2001:1ba0:2a0:5965:0:30:24:1) from 2001:418:1::62, 64 hops max, 16 byte packets 1 2001:418:1::4 0.342 ms 2 2001:418:1::1 0.630 ms 3 2001:504:16::1b1b 0.393 ms 4... (6 Replies)
Discussion started by: sam127
6 Replies

3. Shell Programming and Scripting

sorting

Hi all, Does anyone can help me the following question? I would like to write an AWK script. In the following input file, each number in "start" is paired with numbers in column "end". No Start End A 22,222,33,22,1233,3232,44 555,333,222,55,1235,3235,66... (7 Replies)
Discussion started by: phoeberunner
7 Replies

4. UNIX for Advanced & Expert Users

HELP on sorting

hi everyone, I am kind of new to this forum. I need help in sorting this data out accordingly, I am actually doing a traceroute application and wants my AS path displayed in front of my address like this; 192.168.1.1 AS28513 AS65534 AS5089 AS5089 .... till the last AS number and if possible... (1 Reply)
Discussion started by: sam127
1 Replies

5. UNIX for Dummies Questions & Answers

HELP on sorting

hi everyone, I am kind of new to this forum. I need help in sorting this data out accordingly, I am actually doing a traceroute application and wants my AS path displayed in front of my address like this; 192.168.1.1 AS28513 AS65534 AS5089 AS5089 .... till the last AS number and if possible... (1 Reply)
Discussion started by: sam127
1 Replies

6. Shell Programming and Scripting

Sorting

Let's say that I have a database that I call part ID. This database has the following grouping: Dart1=4 Dart2=8 Dart3=12 Fork1=68 Fork2=72 Fork3=64 Bike1=28 Bike2=24 Bike3=20 Car1=44 Car2=40 Car3=36 I want to write a program that would read this database and tell me when the... (19 Replies)
Discussion started by: Ernst
19 Replies

7. Homework & Coursework Questions

Sorting help

i have list of files: Wang De Wong CVPR 09.pdf Yaacob AFGR 99 Second edition.pdf Shimon CVPR 01.pdf Den CCC 97 long one.pdf Ronald De Bour CSPP 04.pdf ..... how can i sort this directory so the output will be in the next format: <year>\t<conference/journal>\t<author list> - t is tab (its... (1 Reply)
Discussion started by: nirnir26
1 Replies

8. UNIX for Dummies Questions & Answers

Sorting help

i have list of files: Wang De Wong CVPR 09.pdf Yaacob AFGR 99 Second edition.pdf Shimon CVPR 01.pdf Den CCC 97 long one.pdf Ronald De Bour CSPP 04.pdf ..... how can i sort this directory so the output will be in the next format: <year>\t<conference/journal>\t<author list> - t is tab (its... (1 Reply)
Discussion started by: nirnir26
1 Replies

9. UNIX for Dummies Questions & Answers

Sorting help

how can i sort the next list just by look at the numbers (ignore letters) example: abc123 dff4f aaa2aa bbbb55555bb output: aaa2aa dff4f abc123 bbbb55555bb (1 Reply)
Discussion started by: nirnir26
1 Replies

10. Shell Programming and Scripting

Need immediate help with sorting!!!

hey, I have a file that looks smthng like this: /*--- abcd_0050 ---*/ asdfjk adsfkja lkjljgafsd /*---abcd_0005 ---*/ lkjkljbfkgj ldfksjgf dfkgfjb /*-- abcd_0055--*/ klhfdghd dflkjgd jfdg I would like it to be sorted so that it looks like this: /*---abcd_0005 ---*/ lkjkljbfkgj (9 Replies)
Discussion started by: sasuke_uchiha
9 Replies
Login or Register to Ask a Question