Integration - Transformation: Parse Text

This transformation extracts individual words in an attribute by position.

Examples of Use Cases

1. If the email attribute has multiple email addresses, you can parse out one of them and send that back to the target system.
2. If you have an address attribute that contains a full address: e.g. 123 Main Street, Normal, IL, United States: you can parse out only the State (back to front, position 3) - the result would be IL. 

1. Choose Task Template: begin by selecting the Parse Text task template.
2. Select Attribute: select the attribute that you'd like to extract words from.
3. Delimiter: Type the delimiter that identifies where to begin parsing. (i.e. if words in the attribute are separated by commas, you would type a comma). Note: a space can be used as a delimiter
4. Direction of parsing: Options are Front to back (starting from the left) or Back to front (starting from the right)
5. Position:  Type the number that indicates which word should be extracted.

Remember to click Save to save the transformation to your project.