https://community.splunk.com/t5/Splunk-Search/where-clause-issues-stripping-out-extraneous-characters/m-p/174304#M50017 <P>Try this:</P> <PRE><CODE>... | eval NoPct=rtrim(Use%,"%") </CODE></PRE> Thu, 07 May 2015 15:45:12 GMT woodcock 2015-05-07T15:45:12Z https://community.splunk.com/t5/Splunk-Search/where-clause-issues-stripping-out-extraneous-characters/m-p/174303#M50016 <P>Hi,</P> <P>I need to do a where clause on a value that includes a % in the result, how can I strip off the percentage character so I can do a numerical where evaluation? </P> <P>11:06:44 05/07/2015 good 1048333195 [Linux][Baseline][lrtp23][FileSystem][/boot] FileSystems\/boot\Use%=47% 7:45845 0 47</P> <P>The "Use%" is a field, but the values get the percentage stored with them. </P> Thu, 07 May 2015 15:11:55 GMT https://community.splunk.com/t5/Splunk-Search/where-clause-issues-stripping-out-extraneous-characters/m-p/174303#M50016 a212830 2015-05-07T15:11:55Z https://community.splunk.com/t5/Splunk-Search/where-clause-issues-stripping-out-extraneous-characters/m-p/174304#M50017 <P>Try this:</P> <PRE><CODE>... | eval NoPct=rtrim(Use%,"%") </CODE></PRE> Thu, 07 May 2015 15:45:12 GMT https://community.splunk.com/t5/Splunk-Search/where-clause-issues-stripping-out-extraneous-characters/m-p/174304#M50017 woodcock 2015-05-07T15:45:12Z