NotRight
Returns what remains after excluding the right part of a text value.
Variants
NotRight(Text text, Numeric number)
Returns what remains after excluding the rightmost number of characters from the text argument.
Parameters
- text
- The text string that contains the characters you want to extract.
- number
- Specifies the number of rightmost characters you want to exclude before returning the remaining characters.
Returns
Text
Examples
NotRight("typeABC", 3)returns "type".
NotRight(Text text, Text delimiter)
Returns what remains after excluding the right part of a text value starting at the last occurrence of a delimiter value.
Parameters
- text
- The text string that contains the characters you want to extract.
- delimiter
- The delimiter string.
Returns
Text
Remarks
If the text does not include the delimiter, a blank value is returned.
Examples
NotRight("Jane Smith", " ")returns the text value "Jane".NotRight("type-20A", "-")returns the text value "type".NotRight("type-20A", "/")returns a blank value.NotRight("type-20A", "/-")returns a blank value.