Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Text functions > LeftWords function |
|
|
| LeftWords function |
| Format |
LeftWords(text;numberOfWords) |
| Parameters |
| text - any text expression or text field |
| numberOfWords - any numeric expression or field containing a number |
| Data type returned |
| text |
| Description |
| Returns a text result containing the numberOfWords in text, counting from the left. |
| Note The ampersand (&) and hyphen (-) characters identify the beginning of a new word. |
| Examples |
| LeftWords("Plaid Canvas Suitcase";2) returns Plaid Canvas. |
| LeftWords(Name;1) returns Sophie, when the Name field contains Sophie Tang. |
| 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 > LeftWords function |
|
|
Next Page |
|