Extract a word or string from a character field.
NOTE: If the delimiter is blank, (ie: ' ') then consecutive delimiters as treated as one unless overridden by left argument
word ADDRESS ',' N
word ADDRESS ',' (-N)
(Option) word TextField Delimiter Position
Name | Data Type | Input Type | Description | Optional | Default |
---|---|---|---|---|---|
Option | Numeric | Constant | 0 - Treat Consecutive Delimiters separately; 1 - Treat Consecutive Delimiters as one, 2 - Treat only blanks as consecutive delimiters (default); | No |
Name | Data Type | Input Type | Description | Optional | Default |
---|---|---|---|---|---|
TextField | Text | Field, Constant | Raw data | No | |
Delimiter | Text | Constant | No | ||
Position | Numeric | Constant | No |
Type: Text