Result Type: Text
Definition: Returns the left-most count characters from string.
Left("nybble", 3) returns “nyb”.
If boolInBytes is true or IN_BYTES (which is a constant with value true), then the count is regarded as bytes, not characters. This option should only be used when the string is known to be pure ASCII. It is much faster because it does not account for multibyte unicode characters.
Dice: Get a subcomponent of a delimited tabular string
Head: Get some elements from the start of a delimited string
Mid: Get characters from the middle of a string
Regex_Match: Test whether a string matches a regular expression
Regex_Replace: Replace text in a string using a regular expression
Regex_Search: Find the first match of a regular expression in a string
Replace: Replace matching text in a string with new text
Right: Get characters from the end of a string
Slice: Get a component of a delimited string
Tail: Get some elements from the end of a delimited string
Trim: Remove whitespace from beginning and end of a string