FirstWord / String Layer

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

Common applications:

Extracting first names
Getting primary categories
Processing command words
Extracting leading codes
Finding primary tags
Getting main keywords

Table

Select

column

The string column to extract from. Examples of extraction:

'John Doe Smith' → 'John'
' First Second' → 'First'
'SingleWord' → 'SingleWord' Maximum input length: 128 characters

AsColumn

name

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.