@LeftBack (Formula Language)
Searches a string from right to left and returns a substring.
Syntax
@LeftBack( stringToSearch ; numToSkip ) or @LeftBack( stringToSearch ; startString )
Parameters
stringToSearch
Text or text list. The string where you want to find the leftmost characters.
numToSkip
Number. Counting from right to left, the number of characters to skip. All the characters to the left of that number of characters are returned. If the number is negative, the entire string is returned.
startString
Text. A substring of stringToSearch. All the characters to the left of startString are returned.
Return value
resultString
Text or text list. The leftmost characters in stringToSearch. The number of characters returned is determined by either numToSkip or startString.
Usage
If the first parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.
Examples
- This example returns Lennard Wall.
@LeftBack("Lennard Wallace";3) - This example returns Lennard.
@LeftBack("Lennard Wallace"; " ") - This example returns Timothy Alt if the string in the Author field
is Timothy Altman.
@LeftBack(Author;3) - This example returns Lenn and Wall in a list.
@LeftBack("Lennard" : "Wallace"; 3)