topic How to extract trailing numbers from a string with rex in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-extract-trailing-numbers-from-a-string-with-rex/m-p/462572#M130417 <P>I'm trying to extract a string (alphabets and underscore) from a given string which can contain any number of numeric values in the end.</P> <PRE><CODE> rex field=_raw "type: (?.*)\d*$" </CODE></PRE> <P>ex. <BR /> type: alphabets123 | <STRONG>alphabet</STRONG><BR /> type: extract1 | <STRONG>extract</STRONG><BR /> type: write_regex23| <STRONG>write_regex</STRONG></P> Wed, 30 Sep 2020 01:54:33 GMT hmbisht 2020-09-30T01:54:33Z How to extract trailing numbers from a string with rex https://community.splunk.com/t5/Splunk-Search/How-to-extract-trailing-numbers-from-a-string-with-rex/m-p/462572#M130417 <P>I'm trying to extract a string (alphabets and underscore) from a given string which can contain any number of numeric values in the end.</P> <PRE><CODE> rex field=_raw "type: (?.*)\d*$" </CODE></PRE> <P>ex. <BR /> type: alphabets123 | <STRONG>alphabet</STRONG><BR /> type: extract1 | <STRONG>extract</STRONG><BR /> type: write_regex23| <STRONG>write_regex</STRONG></P> Wed, 30 Sep 2020 01:54:33 GMT https://community.splunk.com/t5/Splunk-Search/How-to-extract-trailing-numbers-from-a-string-with-rex/m-p/462572#M130417 hmbisht 2020-09-30T01:54:33Z Re: How to extract trailing numbers from a string with rex https://community.splunk.com/t5/Splunk-Search/How-to-extract-trailing-numbers-from-a-string-with-rex/m-p/462573#M130418 <PRE><CODE>| makeresults | eval x="type: write_regex23" | rex field=x "\:+(?&lt;extract&gt;.*?)\d+" </CODE></PRE> <P>replace x by your source field and remove makeresults</P> Tue, 27 Aug 2019 18:51:46 GMT https://community.splunk.com/t5/Splunk-Search/How-to-extract-trailing-numbers-from-a-string-with-rex/m-p/462573#M130418 Sukisen1981 2019-08-27T18:51:46Z Re: How to extract trailing numbers from a string with rex https://community.splunk.com/t5/Splunk-Search/How-to-extract-trailing-numbers-from-a-string-with-rex/m-p/462574#M130419 <P>hi @hmbisht <BR /> Please accept the anser if it significantly helped resolve your issue or let us know if there are any more issues</P> Wed, 28 Aug 2019 18:50:25 GMT https://community.splunk.com/t5/Splunk-Search/How-to-extract-trailing-numbers-from-a-string-with-rex/m-p/462574#M130419 Sukisen1981 2019-08-28T18:50:25Z Re: How to extract trailing numbers from a string with rex https://community.splunk.com/t5/Splunk-Search/How-to-extract-trailing-numbers-from-a-string-with-rex/m-p/462575#M130420 <P>Thanks a lot @Sukisen1981</P> Thu, 29 Aug 2019 00:22:19 GMT https://community.splunk.com/t5/Splunk-Search/How-to-extract-trailing-numbers-from-a-string-with-rex/m-p/462575#M130420 hmbisht 2019-08-29T00:22:19Z