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().