topic Re: Split the URL by using splunk for getting count for the URL's with out special characters in Getting Data In https://community.splunk.com/t5/Getting-Data-In/Split-the-URL-by-using-splunk-for-getting-count-for-the-URL-s/m-p/500929#M85329 <P>Hi Mathias Lindblom,<BR /> thanks for the update. </P> Fri, 06 Dec 2019 05:56:40 GMT kanamarlapudive 2019-12-06T05:56:40Z Split the URL by using splunk for getting count for the URL's with out special characters https://community.splunk.com/t5/Getting-Data-In/Split-the-URL-by-using-splunk-for-getting-count-for-the-URL-s/m-p/500927#M85327 <P>how to split URL's like below mentioned into one URL, how to do it in splunk sample URL<BR /><BR /> <A href="https://google.co.in/v4/locations/dfdfd">https://google.co.in/v4/locations/dfdfd</A> <BR /> <A href="https://google.co.in/v4/locations/dfad">https://google.co.in/v4/locations/dfad</A> </P> <P>I would like to see <A href="https://google.co.in/v4/locations/">https://google.co.in/v4/locations/</A> as 2</P> Wed, 04 Dec 2019 11:11:27 GMT https://community.splunk.com/t5/Getting-Data-In/Split-the-URL-by-using-splunk-for-getting-count-for-the-URL-s/m-p/500927#M85327 kanamarlapudive 2019-12-04T11:11:27Z Re: Split the URL by using splunk for getting count for the URL's with out special characters https://community.splunk.com/t5/Getting-Data-In/Split-the-URL-by-using-splunk-for-getting-count-for-the-URL-s/m-p/500928#M85328 <P>Hi, have you tried extracting first part of the URL with a regex?<BR /> for example, if you have the URL extracted you could try:</P> <PRE><CODE>&lt;your search&gt; | rex field=URL "(?P&lt;URLpath&gt;https:\/\/.*\/(?!\s))" | stats count by URLpath </CODE></PRE> <P>This will grab everything exept the last part of the URL and count them as URLpaths.</P> Wed, 04 Dec 2019 14:04:06 GMT https://community.splunk.com/t5/Getting-Data-In/Split-the-URL-by-using-splunk-for-getting-count-for-the-URL-s/m-p/500928#M85328 MathiasLindblom 2019-12-04T14:04:06Z Re: Split the URL by using splunk for getting count for the URL's with out special characters https://community.splunk.com/t5/Getting-Data-In/Split-the-URL-by-using-splunk-for-getting-count-for-the-URL-s/m-p/500929#M85329 <P>Hi Mathias Lindblom,<BR /> thanks for the update. </P> Fri, 06 Dec 2019 05:56:40 GMT https://community.splunk.com/t5/Getting-Data-In/Split-the-URL-by-using-splunk-for-getting-count-for-the-URL-s/m-p/500929#M85329 kanamarlapudive 2019-12-06T05:56:40Z