https://community.splunk.com/t5/Splunk-Search/How-to-replace-field-value-by-string-if-certain-condition/m-p/569476#M198485 <P>It is Value that you need to convert to a number for the numeric comparison to work not converting the number to a string</P><LI-CODE lang="markup">| eval Value=if(tonumber(Value)&lt;=0.02,"Good",Value)</LI-CODE> Sun, 03 Oct 2021 11:48:42 GMT ITWhisperer 2021-10-03T11:48:42Z https://community.splunk.com/t5/Splunk-Search/How-to-replace-field-value-by-string-if-certain-condition/m-p/569469#M198479 <P>How do I replace a value for a field if the value is lesser than 0.02 by "Good"?</P><TABLE border="0" width="192" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="64" height="19">Value</TD><TD width="64">Key</TD><TD width="64">date</TD></TR><TR><TD height="19">0.02</TD><TD>1</TD><TD>1/1/2017</TD></TR><TR><TD height="19">0.02</TD><TD>1</TD><TD>1/2/2017</TD></TR><TR><TD height="19">0.05</TD><TD>1</TD><TD>1/3/2017</TD></TR><TR><TD height="19">0.02</TD><TD>1</TD><TD>1/4/2017</TD></TR><TR><TD height="19">0.02</TD><TD>1</TD><TD>1/5/2017</TD></TR><TR><TD height="19">0.02</TD><TD>1</TD><TD>1/6/2017</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Suppose the value is lesser than 0.02, I want to replace the value by string "Good"</P><P>&nbsp;</P><TABLE border="0" width="192" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="64" height="19">Value</TD><TD width="64">Key</TD><TD width="64">date</TD></TR><TR><TD height="19">Good</TD><TD>1</TD><TD>1/1/2017</TD></TR><TR><TD height="19">Good</TD><TD>1</TD><TD>1/2/2017</TD></TR><TR><TD height="19">0.05</TD><TD>1</TD><TD>1/3/2017</TD></TR><TR><TD height="19">Good</TD><TD>1</TD><TD>1/4/2017</TD></TR><TR><TD height="19">Good</TD><TD>1</TD><TD>1/5/2017</TD></TR><TR><TD height="19">Good</TD><TD>1</TD><TD>1/6/2017</TD></TR></TBODY></TABLE> Sun, 03 Oct 2021 08:33:14 GMT https://community.splunk.com/t5/Splunk-Search/How-to-replace-field-value-by-string-if-certain-condition/m-p/569469#M198479 sndpgiri 2021-10-03T08:33:14Z https://community.splunk.com/t5/Splunk-Search/How-to-replace-field-value-by-string-if-certain-condition/m-p/569471#M198481 <LI-CODE lang="markup">| eval Value=if(Value&lt;=0.02,"Good",Value)</LI-CODE> Sun, 03 Oct 2021 08:51:39 GMT https://community.splunk.com/t5/Splunk-Search/How-to-replace-field-value-by-string-if-certain-condition/m-p/569471#M198481 ITWhisperer 2021-10-03T08:51:39Z https://community.splunk.com/t5/Splunk-Search/How-to-replace-field-value-by-string-if-certain-condition/m-p/569472#M198482 <P>I get this error:&nbsp;<BR />Error in 'eval' command: Type checking failed. The '&lt;=' operator received different types.</P><P>When I use a single quote outside the value, I get&nbsp;No result</P><P>&nbsp;</P><LI-CODE lang="markup">| eval Value=if(Value&lt;='0.02',"Good",Value)</LI-CODE><P>&nbsp;</P><DIV class="lia-panel lia-panel-standard MessageTagsTaplet Chrome lia-component-message-view-widget-tags"><DIV class="lia-decoration-border"><DIV class="lia-decoration-border-top">&nbsp;</DIV><DIV class="lia-decoration-border-content"><DIV><DIV class="lia-panel-content-wrapper"><DIV class="lia-panel-content"><DIV class="AddMessageTags lia-message-tags">&nbsp;</DIV></DIV></DIV></DIV></DIV></DIV></DIV> Sun, 03 Oct 2021 09:04:07 GMT https://community.splunk.com/t5/Splunk-Search/How-to-replace-field-value-by-string-if-certain-condition/m-p/569472#M198482 sndpgiri 2021-10-03T09:04:07Z https://community.splunk.com/t5/Splunk-Search/How-to-replace-field-value-by-string-if-certain-condition/m-p/569476#M198485 <P>It is Value that you need to convert to a number for the numeric comparison to work not converting the number to a string</P><LI-CODE lang="markup">| eval Value=if(tonumber(Value)&lt;=0.02,"Good",Value)</LI-CODE> Sun, 03 Oct 2021 11:48:42 GMT https://community.splunk.com/t5/Splunk-Search/How-to-replace-field-value-by-string-if-certain-condition/m-p/569476#M198485 ITWhisperer 2021-10-03T11:48:42Z