Substring
Returns a string containing a substring of consecutive characters from another string.
Syntax
Substring(text,startPosition,length)
Enabled For
For a description of the business object categories, see Notes on "Enabled For".
| Business Object Category | Yes/No |
|---|---|
| Business Rules: Before-Save Rules | Yes |
| Business Rules: Calculation Rules (After Save, with or without Also Recalculate on Load) | Yes |
| Business Rules: Calculation Rules (Before Save or Always, without Also Recalculate On Load) | Yes |
| Business Rules: Calculation Rules (Before Save or Always, with Recalculate On Load) | Yes |
| Business Rules: Editing Rules | Yes |
| Business Rules: Initialization Rules | Yes |
| Business Rules: Read Only Rules | Yes |
| Business Rules: Required Rules | Yes |
| Business Rules: Validation Rules | Yes |
| Client Expressions | Yes |
| Object Permissions | Yes |
| Services | Yes |
| LDAP | Yes |
| Mobile | Yes |
| Quick Actions (except UI Quick Actions) | Yes |
| UI Quick Actions | Yes |
| Reports | Yes |
| Search/Dashboard without field references | Yes |
| Search/Dashboard with field references | Yes |
Parameters
| Parameter | Description |
|---|---|
|
text |
The text from which to extract the substring. |
|
startPosition |
The position of the first character to include in the output. The first character starts with position 1. |
|
length |
(Optional) The length of the substring. |
Return Value
Text value.
Example
$(Substring(Symptom, 21, 7))
If the Symptom field in the current business object contains the following:
Printer seems to be working fine for others. His setup for the printer is fine.
It returns the substring starting with the 21st character and continues for 7 characters. The result of this function in this example is working.
See also Substring0().