Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference WORD
Functions and Expressions Reference Guide
224
WORD ( Line1:Letter , " " , 6 )
If the nth separator is missing and the nth-1 separator exists, the function
returns the characters between the last separator and the end of the delimited
text item. In this example,
WORD returns "winner!" The separator is a space
and "winner!, including the exclamation point, is the sixth word.
WORD ( Line2:Letter , "!" , 3 )
If both nth and nth-1 separators are missing, as in this example, WORD returns
NONE. In this example, there is only one separator, located at the end of the
text object. As a result, there is no third word because the function sees
everything before "!" as the first word.
WORD ( Line1:Letter , " " , 1 )
If n-1 = 0, the function returns the characters between the beginning of the
delimited text item and the first separator. In this example,
WORD returns
Congratulations,.
WORD ( Line1:Letter , " " , -1 )
If n+1 = 0, then the function returns the characters between the end of the
text item and the last separator. In this example,
WORD returns "winner!".
Uses
Use
WORD to parse a text item that is delimited by some character, such as a
space or a comma.
Related Functions
FIND, MID