Extract Part of a Text String

To extract a substring from a text string you use the Substring function.

The syntax for using the substring function is:

• Substring("<text>", <offset>, <length>)

To use the substring function you need to specify:

1. the offset number - this represents the number of characters from the beginning of the string, including spaces.
2. the length number - this is the number of characters collected, starting at the offset point.

For example, to extract the substring 'johns' from the text string 'johnsmith' you could write the following rule:

username = Substring("johnsmith", 0, 5)