.. _split-text-snip:

================
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