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)
or in Excel for example, when ID is equal to "001":
ID | Username |
"001" | Substring("johnsmith", 0, 5) |