The Split transformation creates one or more new attributes from the original value. You can only split String attributes.
For example, the values of a Vehicle Type attribute for vehicles consists of the vehicle make and model separated by a colon (Honda:Civic, Toyota:Camry). You could then use the split transformation to create a Make attribute and a Model attribute.
For example, you might split the attribute after a comma or colon. If the delimiter occurs multiple times, the value is split after the first occurrence.
For example, you might split the attribute after the fourth character.
So if a Vehicle Type included the year (1995 Civic, 2003 Camry), then by splitting the value after the fourth character, you could create a Year attribute and a Model attribute.
For example, split the attribute after the word "type".
To split String attribute values:
If you are done making changes to the project data set, you can commit the changes. See Running the transformation script against a project data set.