https://community.splunk.com/t5/Splunk-Search/How-to-convert-version-number-to-numerical-value/m-p/534395#M151008 <LI-CODE lang="markup">| makeresults | eval version = "7.10.23.1" | rex field=version mode=sed "s/\b(\d)\b/0\1/g s/\.//g"</LI-CODE> Tue, 29 Dec 2020 22:05:32 GMT to4kawa 2020-12-29T22:05:32Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-version-number-to-numerical-value/m-p/534393#M151007 <P>How do I convert the following string value to a numerical value that represents two digits between the dots?</P><P>version = 7.10.23.1</P><P>I would like for this to be converted to a numeric value:</P><P>version = 07102301</P><P>The zero before the 7, does not need to show. I just need to be able to perform &lt;&gt; conditional or comparison functions. I appreciate your help.&nbsp;</P><P>&nbsp;</P> Tue, 29 Dec 2020 21:50:37 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-version-number-to-numerical-value/m-p/534393#M151007 splunkyj 2020-12-29T21:50:37Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-version-number-to-numerical-value/m-p/534395#M151008 <LI-CODE lang="markup">| makeresults | eval version = "7.10.23.1" | rex field=version mode=sed "s/\b(\d)\b/0\1/g s/\.//g"</LI-CODE> Tue, 29 Dec 2020 22:05:32 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-version-number-to-numerical-value/m-p/534395#M151008 to4kawa 2020-12-29T22:05:32Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-version-number-to-numerical-value/m-p/534400#M151011 <P>This worked beautiful!! lol. I tested various numbers, and all tested consistent. Thank you so much&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/184221">@to4kawa</a>&nbsp;</P> Tue, 29 Dec 2020 22:22:09 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-version-number-to-numerical-value/m-p/534400#M151011 splunkyj 2020-12-29T22:22:09Z