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