topic How to write the regex to extract a number within a string and the path that appears after the string in my search results? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-write-the-regex-to-extract-a-number-within-a-string-and/m-p/258768#M77532 <P>The following were the strings visible in my Splunk search results…</P> <PRE><CODE>An error occurred at line: 127 in the jsp file: /uk/store.jsp An error occurred at line: 23 in the jsp file: /browse/find_it_content.jsp An error occurred at line: 1 in the jsp file: /browse/find_it_content.jsp </CODE></PRE> <P>Now I want to extract the field and display the count for the path that appears after the string <CODE>An error occurred at line: 1 in the jsp file:</CODE> and also for the line number it appeared. </P> <P>Need the results like this :</P> <PRE><CODE>Line_number file count 56 /browse/stats.jsp (some count) …. …….. (some count) </CODE></PRE> Mon, 05 Oct 2015 20:07:50 GMT pavanae 2015-10-05T20:07:50Z How to write the regex to extract a number within a string and the path that appears after the string in my search results? https://community.splunk.com/t5/Splunk-Search/How-to-write-the-regex-to-extract-a-number-within-a-string-and/m-p/258768#M77532 <P>The following were the strings visible in my Splunk search results…</P> <PRE><CODE>An error occurred at line: 127 in the jsp file: /uk/store.jsp An error occurred at line: 23 in the jsp file: /browse/find_it_content.jsp An error occurred at line: 1 in the jsp file: /browse/find_it_content.jsp </CODE></PRE> <P>Now I want to extract the field and display the count for the path that appears after the string <CODE>An error occurred at line: 1 in the jsp file:</CODE> and also for the line number it appeared. </P> <P>Need the results like this :</P> <PRE><CODE>Line_number file count 56 /browse/stats.jsp (some count) …. …….. (some count) </CODE></PRE> Mon, 05 Oct 2015 20:07:50 GMT https://community.splunk.com/t5/Splunk-Search/How-to-write-the-regex-to-extract-a-number-within-a-string-and/m-p/258768#M77532 pavanae 2015-10-05T20:07:50Z Re: How to write the regex to extract a number within a string and the path that appears after the string in my search results? https://community.splunk.com/t5/Splunk-Search/How-to-write-the-regex-to-extract-a-number-within-a-string-and/m-p/258769#M77533 <P>This should get you started.</P> <PRE><CODE>... | rex "An error occurred at line: (?&lt;Line_number&gt;\d+) in the jsp file: (?&lt;file&gt;.*)" | stats count by Line_number file | table Line_number file count </CODE></PRE> Mon, 05 Oct 2015 20:32:29 GMT https://community.splunk.com/t5/Splunk-Search/How-to-write-the-regex-to-extract-a-number-within-a-string-and/m-p/258769#M77533 richgalloway 2015-10-05T20:32:29Z Re: How to write the regex to extract a number within a string and the path that appears after the string in my search results? https://community.splunk.com/t5/Splunk-Search/How-to-write-the-regex-to-extract-a-number-within-a-string-and/m-p/258770#M77534 <P>Worked Great Thanks.</P> Mon, 05 Oct 2015 21:04:41 GMT https://community.splunk.com/t5/Splunk-Search/How-to-write-the-regex-to-extract-a-number-within-a-string-and/m-p/258770#M77534 pavanae 2015-10-05T21:04:41Z