ToInteger / String Layer
Convert string values to 64-bit integers using specified base (radix). Similar to Python's int(str, base) or Rust's string to i64 parsing. Handles different number systems. Useful for:
- Converting text numbers to integers
- Processing hexadecimal values
- Working with binary string data
- Parsing custom number formats
Table
0
0
Table
Select
columnThe string column containing numeric text. Must contain valid numbers in the specified base system.
Base
u32Number base (Base
) for parsing. Common values:
- 2 for binary (11001 -> 25)
- 8 for octal (31 -> 25)
- 10 for decimal (25 -> 25)
- 16 for hexadecimal (19 or 0x19 -> 25)
Strict
boolControls error handling:
true
: Raises error for invalid numbers or overflowfalse
: Returns null for any conversion failure
Use true
for data validation, false
for flexible processing
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn
matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.