mid( text, start_num, num_chars )
Returns a substring from the middle of the specified text.
Keyword | Type | Description |
---|---|---|
|
Text |
The text from which the substring will be extracted. |
|
Number |
The positional index of the first character of the substring to be returned. |
|
Number |
The length in characters of the substring to extract. |
Text
The first character of the entire text value is considered to have an index = 1.
mid("boston",4,2)
returns to
Feature | Compatibility | Note |
---|---|---|
Portals | Compatible | |
Offline Mobile | Compatible | |
Sync-Time Custom Record Fields | Compatible | Can be used to create a custom record field that only evaluates at sync time. |
Real-Time Custom Record Fields | Incompatible | Custom record fields that evaluate in real time must be configured using one or more Custom Field functions. |
Process Reports | Compatible | |
Process Events | Compatible |
mid() Function