Purpose
Extract individual words in a string by position.
Category Location: All, calculate or manipulate
Field description
- Text attribute to parse – Pick attribute to parse.
- Text delimiter – Delimiter between words. Default is space. To change to another delimiter, delete the space and then add the new delimiter.
- Direction of Parsing – "Front to back" or "Back to front".
- Position – Position of word to extract.
- Target field – Field to write output.
Examples
- Parse the Full Name attribute: "John Smith"
- First Name: "John"
- Last Name: "Smith"
- Parse Street Address "1234 Main Street"
- Building Number: "1234"
- Street Name: "Main"
- Street Type: "Street"
- 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"