https://community.splunk.com/t5/Splunk-Search/How-to-grep-a-number-from-a-string/m-p/214290#M62836 <P>Hi,</P> <P>I have a column in my source with different severity levels, for example -</P> <H2>Severity</H2> <P>1 - High<BR /> 2 - Medium<BR /> 3 - Moderate<BR /> 4 - Low<BR /> 5 - Planning</P> <P>From the query I need to extract only the numbers i.e. 1, 2 etc. I have tried some answers but haven't been able to get only the number. </P> <PRE><CODE>.......| rex field=severity .severity=(?P&lt;severity&gt;\d+) | table severity </CODE></PRE> <P>If anyone is aware kindly help. <BR /> Thanks in advance. Best regards.</P> Fri, 04 Sep 2015 12:30:18 GMT nilotpaldutta 2015-09-04T12:30:18Z https://community.splunk.com/t5/Splunk-Search/How-to-grep-a-number-from-a-string/m-p/214290#M62836 <P>Hi,</P> <P>I have a column in my source with different severity levels, for example -</P> <H2>Severity</H2> <P>1 - High<BR /> 2 - Medium<BR /> 3 - Moderate<BR /> 4 - Low<BR /> 5 - Planning</P> <P>From the query I need to extract only the numbers i.e. 1, 2 etc. I have tried some answers but haven't been able to get only the number. </P> <PRE><CODE>.......| rex field=severity .severity=(?P&lt;severity&gt;\d+) | table severity </CODE></PRE> <P>If anyone is aware kindly help. <BR /> Thanks in advance. Best regards.</P> Fri, 04 Sep 2015 12:30:18 GMT https://community.splunk.com/t5/Splunk-Search/How-to-grep-a-number-from-a-string/m-p/214290#M62836 nilotpaldutta 2015-09-04T12:30:18Z https://community.splunk.com/t5/Splunk-Search/How-to-grep-a-number-from-a-string/m-p/214291#M62837 <P>Your regex string is good. The rex command syntax is incorrect. Try this:</P> <PRE><CODE>...| rex field=severity "(?P&lt;severity&gt;\d+)" | table severity </CODE></PRE> Fri, 04 Sep 2015 12:46:13 GMT https://community.splunk.com/t5/Splunk-Search/How-to-grep-a-number-from-a-string/m-p/214291#M62837 richgalloway 2015-09-04T12:46:13Z