To extract a substring from a text string you use the Substring function.
The syntax for using the substring function is:
To use the substring function you need to specify:
For example, to extract the substring 'johns' from the text string 'johnsmith' you could write the following rule:
username = Substring("johnsmith", 0, 5)