https://community.splunk.com/t5/Splunk-Search/How-to-replace-letters-with-numbers-in-a-string/m-p/275644#M83149 <P>I don't think I would be able to do it since I'm using Web Splunk and have no access to commands.conf. I'm pretty sure one can do it with rex sed, but my level of expertise is not sufficient and I couldn't find any examples that would suit my need.</P> Tue, 13 Sep 2016 12:57:24 GMT wsadowy1 2016-09-13T12:57:24Z https://community.splunk.com/t5/Splunk-Search/How-to-replace-letters-with-numbers-in-a-string/m-p/275642#M83147 <P>I'm trying to convert a long hexadecimal number (md5) to decimal.<BR /> Unfortunately md5_number = tonumber(md5_string,16) does not seem to work, perhaps due to the number's length.<BR /> So I thought I would replace respective letters in the md5 string with numbers. "a" to 10, "b" to 11 ... "f" to 16. The correctness of the final number does not play a role as I only need it to compare two neighboring events using "delta" function, so I need decimal numbers for that purpose.<BR /> Unfortunately I am unable to do it using replace or rex in sed mode.<BR /> Example md5 hash: 6c17f73c47a12dcf494cd95e3e8bd490<BR /> Any help will be appreciated.</P> Tue, 29 Sep 2020 10:57:43 GMT https://community.splunk.com/t5/Splunk-Search/How-to-replace-letters-with-numbers-in-a-string/m-p/275642#M83147 wsadowy1 2020-09-29T10:57:43Z https://community.splunk.com/t5/Splunk-Search/How-to-replace-letters-with-numbers-in-a-string/m-p/275643#M83148 <P>Try creating a custom command and implement your own logic in python to achieve your requirement <BR /> <A href="http://docs.splunk.com/Documentation/Splunk/6.0.8/AdvancedDev/SearchScripts">http://docs.splunk.com/Documentation/Splunk/6.0.8/AdvancedDev/SearchScripts</A></P> Tue, 13 Sep 2016 12:53:23 GMT https://community.splunk.com/t5/Splunk-Search/How-to-replace-letters-with-numbers-in-a-string/m-p/275643#M83148 paramagurukarth 2016-09-13T12:53:23Z https://community.splunk.com/t5/Splunk-Search/How-to-replace-letters-with-numbers-in-a-string/m-p/275644#M83149 <P>I don't think I would be able to do it since I'm using Web Splunk and have no access to commands.conf. I'm pretty sure one can do it with rex sed, but my level of expertise is not sufficient and I couldn't find any examples that would suit my need.</P> Tue, 13 Sep 2016 12:57:24 GMT https://community.splunk.com/t5/Splunk-Search/How-to-replace-letters-with-numbers-in-a-string/m-p/275644#M83149 wsadowy1 2016-09-13T12:57:24Z https://community.splunk.com/t5/Splunk-Search/How-to-replace-letters-with-numbers-in-a-string/m-p/275645#M83150 <P>A crude way, but should work<BR /> (splitting first 8 characters and converting to number and then next 8 chars and converting and then concatenating both)</P> <PRE><CODE>| stats count as echo | eval decimal = tostring(tonumber(substr("D431F2404CA13E22594E5C8B04D3BBB8",1,8),16)) + tostring(tonumber(substr("D431F2404CA13E22594E5C8B04D3BBB8",9,8),16))| fields decimal </CODE></PRE> Tue, 13 Sep 2016 15:40:53 GMT https://community.splunk.com/t5/Splunk-Search/How-to-replace-letters-with-numbers-in-a-string/m-p/275645#M83150 koshyk 2016-09-13T15:40:53Z https://community.splunk.com/t5/Splunk-Search/How-to-replace-letters-with-numbers-in-a-string/m-p/275646#M83151 <P>Thanks!<BR /> I actually managed to achieve my goal by writing a rather lenghty nested replace function:<BR /> tonumber(replace(replace(replace(replace(replace(replace(log_msg_hash,"a","10"),"b","11"),"c","12"),"d","13"),"e","14"),"f","15"))<BR /> It doesn't calculate the number properly but it does create SOME decimal number which primarly was my goal.</P> Tue, 29 Sep 2020 11:00:49 GMT https://community.splunk.com/t5/Splunk-Search/How-to-replace-letters-with-numbers-in-a-string/m-p/275646#M83151 wsadowy1 2020-09-29T11:00:49Z