Extract mid-string characters

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