The SubString function extracts from a text field starting at a specified position (defined using the first #) and continuing for a specified number of characters (defined with the second #).
Function: SubString(Parameter,#,#)
Example | Explanation | Old value | New value |
|---|---|---|---|
If: Activity ID = AADRAW000 | Selects activity AADRAW000 |
|
|
Then: Activity ID = SubString(Activity ID,4,3) | Extracts three characters, beginning with the fourth. | AADRAW000 | RAW |