This transformation extracts individual words in an attribute by position.
- Choose Task Template: begin by selecting the Parse Text task template.
- Select Attribute: select the attribute that you'd like to extract words from.
- 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
- Direction of parsing: Options are Front to back (starting from the left) or Back to front (starting from the right)
- Position: Type the number that indicates which word should be extracted.
Example: Using the criteria shown in the image above for a street address: 123 Main Street, Normal, IL, United States - the result would be 123 Main Street.
Remember to click Save to save the transformation to your project.