LastWord / String Layer

Extract the last word from strings using whitespace as delimiter. Similar to Python's str.split()[-1] or R's word(x, -1). Returns null for empty strings or strings containing only whitespace.

Common applications:

Extracting last names
Getting file extensions
Finding final categories
Processing end tokens
Extracting units of measurement
Getting domain names from emails

Table

Select

column

The string column to extract from. Examples of extraction:

'John Doe Smith' → 'Smith'
'Last Word ' → 'Word'
'SingleWord' → 'SingleWord'

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.