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

column

The string column to pad. Common scenarios:

  • Numeric strings (42 -> 00042)
  • Reference numbers (A1 -> 000A1)
  • Sequential IDs (123 -> 000123)
0

Target width (Length) for padded strings. Examples with length=5:

  • 42 -> 00042
  • 12345 -> 12345
  • ABC -> 00ABC

Strings longer than length remain unchanged

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.