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

column

The string column containing numeric text. Must contain valid numbers in the specified base system.

Base

u32
10

Number 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

bool
true

Controls error handling:

  • true: Raises error for invalid numbers or overflow
  • false: Returns null for any conversion failure

Use true for data validation, false for flexible processing

Name 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.