Find / String Layer

Find the first position (index) where a pattern appears in text. Similar to Python's str.find() or re.search(). Returns numeric indices (0-based) or null if not found. Useful for:

  • Text parsing and extraction
  • Finding delimiter positions
  • Validating text structure
  • Analyzing pattern locations
Table
0
0
Table

Select

column

The string column to search within. Each value will be searched for the first occurrence of the pattern.

Pattern

string

Pattern to find. Can be regex (e.g., \d+ for numbers, @\w+ for mentions) or literal text based on Literal setting. Uses Rust regex syntax.

false

If true, treats Pattern as exact text to find rather than regex. Useful for finding specific words, delimiters, or phrases without regex interpretation.

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.