ZFill / String Layer
Pad strings with leading zeros to reach specified length. Similar to Python's str.zfill() or Rust's format!("{:0>width}"). Particularly useful for:
- Formatting numeric strings (ID numbers)
- Creating fixed-width codes
- Standardizing sequence numbers
- Preparing data for legacy systems
Table
0
0
Table
Select
columnThe string column to pad. Common scenarios:
- Numeric strings (42 -> 00042)
- Reference numbers (A1 -> 000A1)
- Sequential IDs (123 -> 000123)
Length
u32Target width (Length
) for padded strings. Examples with length=5:
- 42 -> 00042
- 12345 -> 12345
- ABC -> 00ABC
Strings longer than length remain unchanged
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.