How to cut the boldened url

Shell Programming and Scripting
1

Following is a Webserver log

138.132.31.125 - mas@zir.com [12/Aug/2008:13:58:30 -0400] "GET HTTPS://post.zir.com/wps/PA\_1\_0\_J4/zrec\_portal/static/images/hdr\_makepayment_gry.gif HTTP/1.1" 200 2421
72.123.254.143 - Unauth [12/Aug/2008:13:58:30 -0400] "GET HTTPS://load.zir.com/servlet/LSCallUMA?servName=retLinkURL&ATTRIBUTECODE=AMSSHSIAQuestion1 HTTP/1.1" 200 233
24.133.144.170 - Unauth [12/Aug/2008:13:58:30 -0400] "GET HTTPS://load.zir.com/un/fw/global/jscript/utility.js HTTP/1.1" 200 4543
38.88.254.53 - nedra@zir.com [12/Aug/2008:13:58:30 -0400] "GET HTTPS://post.zir.com/wps/PA\_1\_0\_J4/zrec\_portal/static/images/btn\_paynow_off.gif HTTP/1.1" 200 1343
138.230.131.50 - Unauth [12/Aug/2008:13:58:30 -0400] "GET HTTPS://load.zir.com/un/fw/def/style/controls.css HTTP/1.1" 200 13138
138.132.31.125 - mas@zir.com [12/Aug/2008:13:58:30 -0400] "GET HTTPS://post.zir.com/wps/PA\_1\_0\_J4/zrec\_portal/static/images/btn\_paynow_off.gif HTTP/1.1" 200 1343
38.31.248.171 - Unauth [12/Aug/2008:13:58:30 -0400] "GET HTTPS://load.zir.com/ls\_launch_error.jsp HTTP/1.1" 302 1343
24.133.144.170 - Unauth [12/Aug/2008:13:58:30 -0400] "GET HTTPS://load.zir.com/un/fw/def/style/default.css HTTP/1.1" 200 542
203.13.72.28 - 53Q532@zir.com [12/Aug/2008:13:58:30 -0400] "GET HTTPS://post.zir.com/mylzir/images/icn_manageautopay.gif HTTP/1.1" 200 378
33.32.242.100 - yicsakatie@zir.net [12/Aug/2008:13:58:30 -0400] "GET HTTPS://labor.zir.com/static/images/corner\_bottom_right.gif HTTP/1.0" 304 0

I need to cut the url part only boldened in Red and sort them according to the number of times they have been requested/accessed.

Basically, trying to use the following command

cut -f7 -d" " request.log | sort | uniq -c | sort | uniq -c

But,
cut -f7 -d" " request.log gives me the following result

HTTPS://post.zir.com/wps/PA\_1\_0\_J4/zrec\_portal/static/images/hdr\_makepayment_gry.gif HTTP/1.1" 200 2421
HTTPS://load.zir.com/servlet/LSCallUMA?servName=retLinkURL&ATTRIBUTECODE=AMSSHSIAQuestion1 HTTP/1.1" 200 233
HTTPS://load.zir.com/un/fw/global/jscript/utility.js HTTP/1.1" 200 4543
HTTPS://post.zir.com/wps/PA\_1\_0\_J4/zrec\_portal/static/images/btn\_paynow_off.gif HTTP/1.1" 200
HTTPS://post.zir.com/wps/PA\_1\_0\_J4/zrec\_portal/static/images/btn\_paynow_off.gif HTTP/1.1" 200

And so on whereas I only want the URL to sort the list.

Please help,

Thanks in Advance

2

try this

cut -d "/" -f 5 filename

3

Thanks a lot, vidyadhar

cut -d "/" -f5 request.log | sort | uniq -c

The above command worked.

Thanks