Convert a number (or it string representation) from one base to another.
Expression categories: Binary, Cast, Numeric
Declared arguments
Expression - Column to convert base. Expression<Byte | Integer | Long | Short | String>
From base - Convert from base. Literal<Integer>
To base - Convert to base. Literal<Integer>
Output type:String
Examples
Example 1: Base case
Argument values:
Expression: 4A801
From base: 16
To base: 10
Output: 305153
Example 2: Base case
Argument values:
Expression: 8
From base: 10
To base: 2
Output: 1000
Example 3: Null case
Argument values:
Expression: input
From base: 10
To base: 16
input
Output
null
null
Example 4: Edge case
Description: When input is made of characters that are outside the base of the given 'from base', only the leading characters up to the first out of base character is considered.
Argument values: