Visit Our UNIX and Linux User Community


sorting help


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sorting help
# 1  
Old 08-31-2010
sorting help

Hi, Please i need help in writing an 'awk' script in sorting the following data;

Code:
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 2001:470:0:39::1 20.324 ms
5 2001:470:0:31::1 19.431 ms
6 2001:470:0:18d::2 27.455 ms
7 2001:470:0:10e::2 88.778 ms
8 2001:470:0:3e::2 162.857 ms
9 2001:7f8:4::7218:1 185.296 ms
10 2001:4de8:d1a1:1111:4::1 183.437 ms
11 2001:4de8:d1a1:1111:1f::2 183.409 ms
12 2001:4de8:d1a1:1111:11::2 190.747 ms
13 2001:1ba0:babe::1:2 188.239 ms
14 2001:1ba0:2a0:5965:0:30:24:1 188.244 ms
 
traceroute6 to 2001:8a8:21:5:216:3eff:fec1:423 (2001:8a8:21:5:216:3eff:fec1:423) from 2001:418:1::62, 64 hops max, 16 byte packets
1 2001:418:1::4 0.348 ms
2 2001:418:1::1 0.664 ms
3 2001:504:16::1b1b 0.352 ms
4 2001:470:0:39::1 26.260 ms
5 2001:470:0:31::1 19.394 ms
6 2001:470:0:18d::2 27.346 ms
7 2001:470:0:10e::2 90.690 ms
8 2001:470:0:3e::2 156.713 ms
9 2001:470:0:3f::2 164.429 ms
10 2001:470:0:47::2 171.232 ms
11 2001:7f8::9be8:0:1 177.971 ms
12 2a01:f8:1:2:1:1:5:2 178.022 ms
13 2a01:f8:2006:6::2 193.299 ms
14 2001:8a8:1:2::30 192.481 ms
15 2001:8a8:1:b::74 192.774 ms
16 2001:8a8:21:5:216:3eff:fec1:423 181.925 ms
 
traceroute6 to 2a00:ec8:401:1:a032::1 (2a00:ec8:401:1:a032::1) from 2001:418:1::62, 64 hops max, 16 byte packets
1 2001:418:1::4 0.479 ms
2 2001:418:0:5000::25 0.693 ms
3 2001:450:2008:100::d 0.619 ms
4 2001:450:2002:1ef::2 169.361 ms
5 2a00:ec8:401:211::1 169.716 ms
6 2a00:ec8:401:1:a032::1 170.081 ms

Its a traceroute results(its a long list in this format for about 7000 addresses) in which I need the IP address and destination address only in this format;
Code:
2001:1ba0:2a0:5965:0:30:24:1 destination is 2001:1ba0:2a0:5965:0:30:24:1
2001:8a8:21:5:216:3eff:fec1:423 destination is 2001:8a8:21:5:216:3eff:fec1:423 
2a00:ec8:401:1:a032::1 destination is 2a00:ec8:401:1:a032::1

so basically is the IP address in first line and the IP address at the last line for each of the sections separated by space as above.

Thanks for your anticipated help.

Moderator's Comments:
Mod Comment Use code tags please.

Last edited by sam127; 08-31-2010 at 11:33 AM..
# 2  
Old 08-31-2010
Will you by this check if the traceroute completed? If this is the case, maybe it is more interessting to check for failed ones(?).
# 3  
Old 08-31-2010
you can run this command and it will help you..

lets just say your file name is test.
Code:
cat test | grep "traceroute6 to " >> tmp_file 
for line in tmp_file
do
echo $line | awk '{print $3 "destination is " $3}' >> final_file
done

# 4  
Old 08-31-2010
Assuming the logical records are separated by an empty lines (no spaces or other non-printable characters):

Code:
awk '{ 
  print $3, "destination is", $(NF - 2) 
  }' RS= infile

This User Gave Thanks to radoulov For This Post:
# 5  
Old 08-31-2010
Hi, Thanks for the urgent help, here is the result displayed when i ran the script;
"destination is"

and thats all i get....bear in mind that the file is not just the 3sections of traceroute displayed above, the section is about 7000.

Thanks
# 6  
Old 08-31-2010
have you used the method that i suggested... above??
This User Gave Thanks to dazdseg For This Post:
# 7  
Old 08-31-2010
thanks a lot radoulov, it worked perfectly

Previous Thread | Next Thread
Test Your Knowledge in Computers #213
Difficulty: Medium
OSPF-TE is an extension to OSPF extending the expressivity to allow for traffic engineering and use on non-IP networks.
True or False?

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

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

3. Shell Programming and Scripting

Sorting HELP

Hi, I have posted related topic but as i continue the research I find more need to sort the data. 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 ... (6 Replies)
Discussion started by: sam127
6 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

Featured Tech Videos