https://community.splunk.com/t5/Splunk-Search/Removing-leading-and-trailing-symbols-from-a-string-for-numeric/m-p/455457#M170539 <P>Thanks. It worked</P> Wed, 03 Jul 2019 16:34:18 GMT bonddodla 2019-07-03T16:34:18Z https://community.splunk.com/t5/Splunk-Search/Removing-leading-and-trailing-symbols-from-a-string-for-numeric/m-p/455455#M170537 <P>I have a field Threshold which has a value "+-5%", "&gt;20%", "&lt;30%" etc, which i want to convert into a number.</P> <P>Could you please suggest how can i remove the leading and trailing symbols so that i can achieve the numeric value only.</P> Wed, 03 Jul 2019 08:49:00 GMT https://community.splunk.com/t5/Splunk-Search/Removing-leading-and-trailing-symbols-from-a-string-for-numeric/m-p/455455#M170537 bonddodla 2019-07-03T08:49:00Z https://community.splunk.com/t5/Splunk-Search/Removing-leading-and-trailing-symbols-from-a-string-for-numeric/m-p/455456#M170538 <P>@bonddodla try the following rex command on your <CODE>Threshold</CODE> field</P> <PRE><CODE>| rex field="Threshold" "(?&lt;Threshold&gt;\d+)" </CODE></PRE> <P>Following is a run anywhere example based on sample data provided in the question</P> <PRE><CODE>| makeresults | eval Threshold="+-5%,&gt;20%,&lt;30%" | makemv Threshold delim="," | mvexpand Threshold | rex field="Threshold" "(?&lt;Threshold&gt;\d+)" </CODE></PRE> Wed, 03 Jul 2019 11:49:12 GMT https://community.splunk.com/t5/Splunk-Search/Removing-leading-and-trailing-symbols-from-a-string-for-numeric/m-p/455456#M170538 niketn 2019-07-03T11:49:12Z https://community.splunk.com/t5/Splunk-Search/Removing-leading-and-trailing-symbols-from-a-string-for-numeric/m-p/455457#M170539 <P>Thanks. It worked</P> Wed, 03 Jul 2019 16:34:18 GMT https://community.splunk.com/t5/Splunk-Search/Removing-leading-and-trailing-symbols-from-a-string-for-numeric/m-p/455457#M170539 bonddodla 2019-07-03T16:34:18Z