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
columnThe string column to check. Each value will be tested for the specified starting pattern.
Prefix
stringText that should appear at the start (Prefix
). Examples:
- USD for currency codes
- 2024- for dates
- test_ for test files
Case-sensitive matching
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.