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

column

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

Suffix

string

The ending text (Suffix) to look for. Examples:

  • .jpg for image files
  • Inc. for company names
  • _test for test data identifiers

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.