https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-decimal-number-to-binary/m-p/263169#M78977 <P>All, </P> <P>Assuming Splunk has a function for this. But for the life of me I can't find it. Is there a tool to convert decimal numbers to binary? Assuming something like this exists:</P> <PRE><CODE>mysearch | eval test=tobinary(mybase10number) </CODE></PRE> Tue, 24 May 2016 19:00:49 GMT daniel333 2016-05-24T19:00:49Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-decimal-number-to-binary/m-p/263169#M78977 <P>All, </P> <P>Assuming Splunk has a function for this. But for the life of me I can't find it. Is there a tool to convert decimal numbers to binary? Assuming something like this exists:</P> <PRE><CODE>mysearch | eval test=tobinary(mybase10number) </CODE></PRE> Tue, 24 May 2016 19:00:49 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-decimal-number-to-binary/m-p/263169#M78977 daniel333 2016-05-24T19:00:49Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-decimal-number-to-binary/m-p/263170#M78978 <P>Hi @daniel333</P> <P>This answer by @javiergn on a previous question might be the solution you're looking for:<BR /> <A href="https://answers.splunk.com/answers/396201/how-to-convert-ip-address-to-binary.html">https://answers.splunk.com/answers/396201/how-to-convert-ip-address-to-binary.html</A></P> Tue, 24 May 2016 19:06:27 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-decimal-number-to-binary/m-p/263170#M78978 ppablo 2016-05-24T19:06:27Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-decimal-number-to-binary/m-p/263171#M78979 <P>This can be done with <CODE>tonumber</CODE>:</P> <PRE><CODE>mysearch | eval test=tonumber(mybase10number, 2) </CODE></PRE> Tue, 24 May 2016 19:08:05 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-decimal-number-to-binary/m-p/263171#M78979 woodcock 2016-05-24T19:08:05Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-decimal-number-to-binary/m-p/263172#M78980 <P>Unfortunately tonumber(mybase10number, 2) converts binary to decimal and not the other way around. So in the following example, the result in 'test' would be 5.</P> <PRE><CODE> mysearch | eval mybase2number=101 | eval test=tonumber(mybase2number, 2) </CODE></PRE> Fri, 18 Nov 2016 09:25:24 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-decimal-number-to-binary/m-p/263172#M78980 Jodge 2016-11-18T09:25:24Z