Split Text¶

Sometimes you have text that has been entered into your system of record as a single field but you need to split the text out into separate fields. For example you have Peoples Names in a single field and you want to split it out into First and Last names.

Rule Type Format¶

split(field name , delimiter)

split(field name , delimiter) [safe_offset(0)]

split(field name , delimiter) [safe_offset(1)]

array_reverse(split(field name , delimiter)) [safe_offset(0)]

Snippits¶

Get First Word¶

Splits out the first word in the text field

Space as the delimiter¶

Rule Type = Calculated Output Field

Rule Attribute = split(Full_name, ” “)[SAFE_OFFSET(0)] : FirstName

Examples¶

robert john james becomes robert
ROBERT JOHN JAMES becomes ROBERT

Get Second Word¶

Splits out the second word in the text field

Space as the delimiter¶

Rule Type = Calculated Output Field

Rule Attribute = split(Full_name, ” “)[SAFE_OFFSET(1)] : FirstName

Examples¶

robert john james becomes robert
ROBERT JOHN JAMES becomes ROBERT

Get Last Word¶

Splits out the last word in the text field

Space as the delimiter¶

Rule Type = Calculated Output Field

Rule Attribute = array_reverse(split(Full_name, ” “)) [SAFE_OFFSET(0)] : Last_name

Examples¶

robert john james becomes james
ROBERT JOHN JAMES becomes JAMES

Get First Word and Title Case it¶

Splits out the first word in the text field, and then Title cases the word.

Space as the delimiter¶

Rule Type = Calculated Output Field

Rule Attribute = initcap(split(Full_name, ” “)[SAFE_OFFSET(0)]) : FirstName

Examples¶

robert john james becomes Robert
ROBERT JOHN JAMES becomes Robert