Trying to sort data


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Trying to sort data
# 1  
Old 06-16-2009
Trying to sort data

Im trying to sort all this data.

I need to get a list out of the data (websites) and just list them out can anyone point me in the right direction. Im working with dans guardian.

2009.6.10 6:26:50 - 192.168.42.200 http://stork43.getdropbox.com/subscr...&ts=1244643933 GET 15
2009.6.10 6:28:05 - 192.168.42.200 http://stork43.getdropbox.com/subscr...&ts=1244643987 GET 15
2009.6.10 6:29:23 - 192.168.42.200 http://stork43.getdropbox.com/subscr...&ts=1244644063 GET 15
2009.6.10 6:30:38 - 192.168.42.200 http://stork43.getdropbox.com/subscr...&ts=1244644140 GET 15
2009.6.10 6:31:53 - 192.168.42.200 http://stork43.getdropbox.com/subscr...&ts=1244644215 GET 15
2009.6.10 6:33:08 - 192.168.42.200 http://stork43.getdropbox.com/subscr...&ts=1244644290 GET 15
2009.6.10 6:34:26 - 192.168.42.200 HP Jumpstation GET 219
2009.6.10 6:34:33 - 192.168.42.200 http://stork43.getdropbox.com/subscr...&ts=1244644365 GET 15
2009.6.10 6:35:48 - 192.168.42.200 http://stork43.getdropbox.com/subscr...&ts=1244644451 GET 15
2009.6.10 6:37:03 - 192.168.42.200 http://stork43.getdropbox.com/subscr...&ts=1244644526 GET 15
2009.6.10 6:38:18 - 192.168.42.200 http://stork43.getdropbox.com/subscr...&ts=1244644601 GET 15
2009.6.10 6:39:43 - 192.168.42.200 http://stork43.getdropbox.com/subscr...&ts=1244644676 GET 15
2009.6.10 6:40:58 - 192.168.42.200 http://stork43.getdropbox.com/subscr...&ts=1244644761 GET 15

Last edited by jim mcnamara; 06-16-2009 at 01:46 PM.. Reason: deleted lots of urls
# 2  
Old 06-16-2009
You've got a lot of problematic links embedded in your post.

What is it you want - just a list of urls?
Code:
awk '{print $5}'  my_url_file > newfile

Please don't post a bunch of links like that. Thanks. I edited your post to remove a lot of them.
# 3  
Old 06-16-2009
all the data still comes up with that code. Smilie im still trying to put it together
# 4  
Old 06-16-2009
Quote:
Originally Posted by darknirvana
all the data still comes up with that code. Smilie im still trying to put it together
what code?
# 5  
Old 06-16-2009
awk '{print $5}' my_url_file > newfile
# 6  
Old 06-17-2009
Code:
sed 's/[^-]*- [^ ]* \(.*\) GET.*/\1/' yourfile

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to sort out data

Hello All, I have one file with multiple lines records like as below.. I need to extract only BFG and corresponding BSG record/line. for evry BFG there is one BSG record is there as mentioned in BOLD and so on... BFG BR 00001 20140724 000 000 ? ? BLG UVR QPR 01 380 ? ? 999 0 0 0 ? BLC... (2 Replies)
Discussion started by: Riverstone
2 Replies

2. Shell Programming and Scripting

Sort data As per first Column

hI I have file A NSU30504 5 6 G 6 NSU3050B T 7 9 J NSU30506 T I 8 9 NSU3050C H J K L Output: NSU3050B T 7 9 J NSU3050C H J K L NSU30504 5 6 G 6 NSU30506 T I 8 9Video tutorial on how to use code tags in The UNIX and Linux Forums. (13 Replies)
Discussion started by: pareshkp
13 Replies

3. UNIX for Dummies Questions & Answers

sort data

Hi, I need to filter the output of a command and display certain data only. How can i do this ? My file contain: $ cat abc.txt <testcase title="AAA_100"> <testcase title="BBB_200"> <testcase title="CCC_300"> <testcase title="DDD"> ... (3 Replies)
Discussion started by: crazydude80
3 Replies

4. Shell Programming and Scripting

Sort Data by Group !

Hello, I have a file and i want to sort by third column and extract the three top lines of each group, it is determined by the second column (144, 89, 55, etc). Could you please help me with the appropiate awk shell script XLY-XLP 144 0.592772 XLY-XLE 144 0.798121 ... (3 Replies)
Discussion started by: csierra
3 Replies

5. Shell Programming and Scripting

Help needed to sort data

Hello All, Today i have been asking lots of question, hope to become good in scripting soon with all the wonderful advices i get. The question is i want to sort data a get uniq string from it. The code i am using to generate the output is:- check_sun() { for i in $SUN_PLATFORM do $ECHO... (0 Replies)
Discussion started by: asirohi
0 Replies

6. UNIX for Advanced & Expert Users

sort out the required data

Hi All, I have a file 1.txt which has the duplicate dns entries as shown: Name: 000f9fbc6738.net.in|Addresses: 10.241.66.169, 10.84.2.222,212.241.66.170 Name: 001371e8ed3e.net.in|Addresses: 10.241.65.153, 10.84.1.101 Name: 00e06f5bd42a.net.in|Addresses: 10.72.19.218,... (6 Replies)
Discussion started by: imas
6 Replies

7. Shell Programming and Scripting

Sort complex data

Hi, Can someone here help sorting the following data in numeric order? INPUT: FIRST abc(3) def(13) fgh(1) ijk(6) abc(2) SECOND dfe(10) abc(4) hij(19) tlm(1) hij(1) hub(10) abc(1) fed(3) OTHERS hij(10) mok(4) bub(19) hij(1) abc(2) abc(15) abc(1) hij(3) OUTPUT: FIRST def(13) ijk(6)... (12 Replies)
Discussion started by: need_help
12 Replies

8. Shell Programming and Scripting

sort data in different columns

Hello all: i have list with the following format Id Name Iid Value 0x4440001 customerCode 44077 0x11d2a PrimaryAddress 57.217.41.201 0x129fa ... (15 Replies)
Discussion started by: mogabr
15 Replies

9. Shell Programming and Scripting

Script to sort data

Hi All, I have a .csv file with 3 columns called nLats, nLongs, and fRes. in following format : "nLats","nLongs","fRes" 0,0,-1 0,1,-1 0,2,-1 0,3,-1 0,4,-1 ......... ......... 0,143,-1 nLats increments at nLongs=143 1,0, -1 1,1, -1 .......... .......... 1,143,-1... (1 Reply)
Discussion started by: wizardy_maximus
1 Replies

10. Shell Programming and Scripting

sort data

Hi! I'm trying to sort a file.dat with the sort command. The data contained by file.dat is similar to the data set below: 100.000 99.000 110.000 55.000 113.000 33.000 25.000 9.000 15.000 It is relatively easy to sort the data in ascending or descending order, but the problem is... (11 Replies)
Discussion started by: bjorb
11 Replies
Login or Register to Ask a Question