Base 10 to Base 36 Conversion In Splunk (Part-II)
In our previous blog of this series “Base 10 to Base 36 Conversion In Splunk (Part-I)” we had shown a way to implement the given stuff using SPL query. Today we will present another alternative way to do the task in hand by using an add-on “Convert Decimal number to any Base” from Splunk base.
The link is given below,
https://splunkbase.splunk.com/app/3222/
At first, we will log in to our instance using the credentials we have.
![](https://i2.wp.com/splunkonbigdata.com/wp-content/uploads/2022/01/1-11.png?resize=671%2C326&ssl=1)
Then from the launcher page click on “Find More Apps”
![](https://i0.wp.com/splunkonbigdata.com/wp-content/uploads/2022/01/2-14.png?resize=696%2C241&ssl=1)
Then search with the add-on the name given below,
“Convert Decimal number to any Base”
![](https://i0.wp.com/splunkonbigdata.com/wp-content/uploads/2022/01/3-14.png?resize=696%2C249&ssl=1)
And click on Install.
Enter your Splunk base credentials.
Click the checkbox to agree to all the terms and conditions and click on “Login and install”
![](https://i1.wp.com/splunkonbigdata.com/wp-content/uploads/2022/01/4-13.png?resize=696%2C579&ssl=1)
After installing the app restart your Splunk server and go to the search and reporting app.
Try this following query to do the required argument.
index="demo" sourcetype="orderNo"
| table OrderNo,Owner
| base10convert OrderNo 36
Result:
![](https://i1.wp.com/splunkonbigdata.com/wp-content/uploads/2022/01/5-13.png?resize=696%2C78&ssl=1)
![](https://i1.wp.com/splunkonbigdata.com/wp-content/uploads/2022/01/6-13.png?resize=696%2C209&ssl=1)
How the add-on is working:
The add-on is basically creating a new command known as “base10convert”, as you know this is not a conventional regular command. Without installing this add-on you can not use this command. Here “base10convert” command will convert and decimal number(base 10) into any base.
Syntax:
….|base10convert <fieldName consisting decimal number> <base>
This is all about “Base 10 to Base 36 Conversion In Splunk (Part-II)“
Happy Splunking!!