Base-36 to Base-10 Conversion in ADX KQL
Tags: azuredataexplorer, kql, basedecimalconversion
Published: 2023-08-21 19:07:00

Base-36 to Base-10 Conversion in ADX KQL
----------------------------------------

When it comes to software development, data manipulation and conversion are often necessary tasks. One such conversion that you may encounter in your development journey is converting numbers from base-36 to base-10. In this article, we will explore how to perform this conversion using ADX KQL (Azure Data Explorer Query Language).

Base-36 is an interesting number system that uses a combination of digits (0-9) and letters (A-Z) to represent numbers. It allows for compact representation of large numbers in a human-readable format. On the other hand, base-10 is the decimal number system that we are most familiar with, using digits 0-9.

Converting a base-36 number to base-10 in ADX KQL is a straightforward process. Let's take a look at an example:

 

    
        let base36Number = "2ZXY";
        let base10Number = toint(base36Number, 36);
        print base10Number;
      

 

In the above code snippet, we have a base-36 number represented by the string "2ZXY". The `toint` function in ADX KQL is used to convert the given string to an integer, specifying the base as 36. The resulting base-10 number is then stored in the `base10Number` variable and printed.

It's important to note that ADX KQL supports base conversions up to base-36. If you need to convert numbers in other bases, you may need to implement custom logic or use external libraries.

Now, let's add a touch of humor to our discussion. Converting numbers from base-36 to base-10 is like deciphering a secret code written by aliens who love using both numbers and letters. It's like solving a puzzle where numbers and alphabets come together for a party, and you are the party planner who knows how to make sense of it all!

So, the next time you encounter a base-36 number in your ADX KQL queries, don't panic! With the power of the `toint` function, you can effortlessly convert it to base-10 and continue with your data analysis.

### References:

*   [ADX KQL toint function documentation](https://docs.microsoft.com/azure/data-explorer/kusto/query/tointfunction)
*   [Base-36 number system on Wikipedia](https://en.wikipedia.org/wiki/Base36)

### Explore more articles on software development and enhance your skills in the field.

*   #### [Aligning MRTK playspace in Unity to QR Code tracked on Hololens 2](https://notes.devcodef1.com//aligning-mrtk-playspace-in-unity-to-qr-code-tracked-on-hololens-2)
    
    Learn how to align the Mixed Reality Toolkit (MRTK) playspace in Unity to a QR Code tracked on Hololens 2. This tutorial will guide you through the process of integrating QR code tracking with MRTK in Unity, allowing for precise spatial alignment in your Hololens 2 applications.
    
*   #### [Need feedback about a system Verilog implementation of a prefix adder](https://devcodef1.com/news/1039788/feedback-on-system-verilog-prefix-adder-implementation)
    
    This article seeks feedback on a system Verilog implementation of a prefix adder. It discusses the challenges faced and invites readers to provide their insights and suggestions.
    
*   #### [How do I privately implement an operator for an STL container?](https://devcodef1.com/news/1039787/implementing-an-operator-for-an-stl-container)
    
    Learn how to privately implement an operator for an STL container in C++. This article explores the concept of operator overloading and demonstrates its application with unordered maps.
    
*   #### [My WordPress Website Has Reached Its Input/Output Usage Limit](https://devcodef1.com/news/1039786/wordpress-i-o-usage-limit)
    
    Learn how to handle the input/output usage limit issue on your WordPress website and ensure its smooth functioning.
    
*   #### [Should my bookstore use .zip files or bundling .pdfs?](https://devcodef1.com/news/1039785/zip-files-or-bundling-pdfs)
    
    Explore the pros and cons of using .zip files versus bundling .pdfs for your bookstore's software development needs. Learn about the advantages and disadvantages of each approach and make an informed decision for your business.