https://community.splunk.com/t5/Splunk-Search/string-to-number-conversion/m-p/17968#M177189 <P>Thank u so much Ayn its worked perfectly now.<BR /> Regards<BR /> Ravi</P> Mon, 04 Feb 2013 08:58:52 GMT kumar518g 2013-02-04T08:58:52Z https://community.splunk.com/t5/Splunk-Search/string-to-number-conversion/m-p/17966#M177187 <P>Hi All,<BR /> i have to convert an extracted field "responcetime" values like ":1389 ms",":345 ms" to number format .as the above field is of type as string its doing sorting as string but want it as number sorting so please help me.</P> <P>Thanks in advance<BR /> Ravi</P> Mon, 04 Feb 2013 07:53:59 GMT https://community.splunk.com/t5/Splunk-Search/string-to-number-conversion/m-p/17966#M177187 kumar518g 2013-02-04T07:53:59Z https://community.splunk.com/t5/Splunk-Search/string-to-number-conversion/m-p/17967#M177188 <P>Just make sure that the "responcetime" field only holds numbers, and Splunk should handle it numerically automatically. For instance you could use <CODE>rex</CODE>.</P> <PRE><CODE>... | rex field=responcetime "^:(?&lt;responcetime&gt;\d+)" | ... </CODE></PRE> Mon, 04 Feb 2013 08:21:53 GMT https://community.splunk.com/t5/Splunk-Search/string-to-number-conversion/m-p/17967#M177188 Ayn 2013-02-04T08:21:53Z https://community.splunk.com/t5/Splunk-Search/string-to-number-conversion/m-p/17968#M177189 <P>Thank u so much Ayn its worked perfectly now.<BR /> Regards<BR /> Ravi</P> Mon, 04 Feb 2013 08:58:52 GMT https://community.splunk.com/t5/Splunk-Search/string-to-number-conversion/m-p/17968#M177189 kumar518g 2013-02-04T08:58:52Z