FORMULA LANGUAGE
Examples: @MiddleBack
1. This example returns Alt if the content of the Author field is Timothy Altman.
@MiddleBack(Author;" ";3)
2. This example returns an empty string if the content of the Author field is any string with no spaces, for example “Smith.”
@MiddleBack(Author;" ";3)
3. This example returns" from right to left" with a space before "from."
@MiddleBack("Middleback searches the string from right to left"; "ing";25)
4. This example returns "searches the string ."
@MiddleBack("@MiddleBack searches the string from right to left"; "from"; -20)
5. This example returns " is the " with spaces before and after "is the." The return string is everything from the fifth to the last character through the character after "This."
@MiddleBack("This is the text"; 5; "This")
6. This example returns " the " with spaces before and after "the." The return string is everything before "text" and after "is."
@MiddleBack("This is the text"; "text"; "is")
7. This example returns "world" and "time" in a list. The offset is the end of each text element and the end text is the last space.
@MiddleBack("Hello world" : "This is the time"; 0; " ")
See Also
@MiddleBack
Glossary
Feedback on
Help
or
Product Usability
?
Help on Help
All Help Contents
Glossary