EndsWith / String Layer
Check if strings in a column end with a specific suffix. Similar to Python's str.endswith(). Returns a boolean column (true for matches). Useful for:
- Checking file extensions (.pdf, .csv)
- Validating email domains (@company.com)
- Finding text patterns (e.g., units like 'kg', '%')
- Identifying categories or classifications
Table
0
0
Table
Select
columnThe string column to check. Each value will be tested for the specified ending pattern.
Suffix
stringThe ending text (Suffix
) to look for. Examples:
- .jpg for image files
- Inc. for company names
- _test for test data identifiers
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.