Extract part of a text string

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:

 

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)