StartsWith / String Layer

Check if strings begin with a specific prefix. Similar to Python's str.startswith(). Returns a boolean column (true for matches). Useful for:

  • Identifying file types (starts with 'log_')
  • Filtering URL protocols (starts with 'https://')
  • Categorizing codes (starts with 'PRD-')
  • Finding specific text patterns
Table
0
0
Table

Select

column

The string column to check. Each value will be tested for the specified starting pattern.

Prefix

string

Text that should appear at the start (Prefix). Examples:

  • USD for currency codes
  • 2024- for dates
  • test_ for test files

Case-sensitive matching

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.