Word Parsing

Purpose

Extract individual words in a string by position.

Category Location: All, calculate or manipulate

Field description

1. Text attribute to parse – Pick attribute to parse.
2. Text delimiter – Delimiter between words. Default is space. To change to another delimiter, delete the space and then add the new delimiter.
3. Direction of Parsing – "Front to back" or "Back to front".
4. Position – Position of word to extract.
5. Target field – Field to write output.

Examples 

1. Parse the Full Name attribute: "John Smith" 

• First Name: "John"
• Last Name: "Smith"

2. Parse Street Address "1234 Main Street"

• Building Number: "1234"
• Street Name: "Main"
• Street Type: "Street"

3. Multiple Emails "joe@email.com, steve@email.com"

• change delimiter to comma (delete blank and add comma)
• first email: "joe@email.com"
• second email: "steve@email.com"