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/subscribe?host\_id=7e8fa872a28ca80e0853a4eaf18dd646&ns\_map=1799586_605566470064928162&ts=1244643933 GET 15
2009.6.10 6:28:05 - 192.168.42.200 http://stork43.getdropbox.com/subscribe?host\_id=7e8fa872a28ca80e0853a4eaf18dd646&ns\_map=1799586_605566470064928162&ts=1244643987 GET 15
2009.6.10 6:29:23 - 192.168.42.200 http://stork43.getdropbox.com/subscribe?host\_id=7e8fa872a28ca80e0853a4eaf18dd646&ns\_map=1799586_605566470064928162&ts=1244644063 GET 15
2009.6.10 6:30:38 - 192.168.42.200 http://stork43.getdropbox.com/subscribe?host\_id=7e8fa872a28ca80e0853a4eaf18dd646&ns\_map=1799586_605566470064928162&ts=1244644140 GET 15
2009.6.10 6:31:53 - 192.168.42.200 http://stork43.getdropbox.com/subscribe?host\_id=7e8fa872a28ca80e0853a4eaf18dd646&ns\_map=1799586_605566470064928162&ts=1244644215 GET 15
2009.6.10 6:33:08 - 192.168.42.200 http://stork43.getdropbox.com/subscribe?host\_id=7e8fa872a28ca80e0853a4eaf18dd646&ns\_map=1799586_605566470064928162&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/subscribe?host\_id=7e8fa872a28ca80e0853a4eaf18dd646&ns\_map=1799586_605566470064928162&ts=1244644365 GET 15
2009.6.10 6:35:48 - 192.168.42.200 http://stork43.getdropbox.com/subscribe?host\_id=7e8fa872a28ca80e0853a4eaf18dd646&ns\_map=1799586_605566470064928162&ts=1244644451 GET 15
2009.6.10 6:37:03 - 192.168.42.200 http://stork43.getdropbox.com/subscribe?host\_id=7e8fa872a28ca80e0853a4eaf18dd646&ns\_map=1799586_605566470064928162&ts=1244644526 GET 15
2009.6.10 6:38:18 - 192.168.42.200 http://stork43.getdropbox.com/subscribe?host\_id=7e8fa872a28ca80e0853a4eaf18dd646&ns\_map=1799586_605566470064928162&ts=1244644601 GET 15
2009.6.10 6:39:43 - 192.168.42.200 http://stork43.getdropbox.com/subscribe?host\_id=7e8fa872a28ca80e0853a4eaf18dd646&ns\_map=1799586_605566470064928162&ts=1244644676 GET 15
2009.6.10 6:40:58 - 192.168.42.200 http://stork43.getdropbox.com/subscribe?host\_id=7e8fa872a28ca80e0853a4eaf18dd646&ns\_map=1799586_605566470064928162&ts=1244644761 GET 15

You've got a lot of problematic links embedded in your post.

What is it you want - just a list of urls?

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.

all the data still comes up with that code. :frowning: im still trying to put it together

what code?

awk '{print $5}' my_url_file > newfile

sed 's/[^-]*- [^ ]* \(.*\) GET.*/\1/' yourfile