Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Text functions > Middle function |
|
|
| Middle function |
| Format |
Middle(text;start;numberOfCharacters) |
| Parameters |
| text - any text expression or text field |
| start - any numeric expression or field containing a number |
| numberOfCharacters - any numeric expression or field containing a number |
| Data type returned |
| text |
| Description |
| Extracts the numberOfCharacters from text, starting at the character position specified by start. |
| Examples |
| Middle("(408)555-9054";2;3) returns 408. |
| Middle(PhoneNumber;2;3) returns 408 when the PhoneNumber field contains (408) 555-9054. |
| Middle("abcdefghij";5;2) returns ef. |
| Middle(Name;Position(Name;" ";1;1)+1;3) returns Smi, when the text field Name contains John Smith. |
| 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 > Middle function |
|
|
Next Page |
|