Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Text functions > MiddleWords function |
|
|
| MiddleWords function |
| Format |
MiddleWords(text;startingWord;numberOfWords) |
| Parameters |
| text - any text expression or text field |
| startingWord - any numeric expression or field containing a number |
| numberOfWords - any numeric expression or field containing a number |
| Data type returned |
| text |
| Description |
| Returns a text result containing the numberOfWords from text, beginning at startingWord. |
| Note The ampersand (&) and hyphen (-) characters identify the beginning of a new word. |
| Examples |
| MiddleWords("Plaid Canvas Suitcase";2;2) returns Canvas Suitcase. |
| MiddleWords(Name;1;2) returns Brigitte Erika, when the Name field contains Brigitte Erika Durand. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Text functions > MiddleWords function |
|
|
Next Page |
|