FORMULA LANGUAGE

Examples: @Middle
1. This example returns h C. The offset is positioned at the "t" (the fourth character from the left), and the count starts with the first character after the offset, moving from left to right.
2. This example returns ort. The offset is positioned at the "t" (the fourth character from the left), and the count begins at the offset, moving from right to left.
3. This example returns Car. The offset is positioned at the first space in the string "North Carolina" and the count starts with the first character after the offset.
4. This example returns or. The offset is positioned at the substring "th" and the count starts with the first character after the entire offset, moving from right to left.
5. This example returns " is the " with spaces before and after "is the." The return string is everything from the fifth character through the character before "text."
6. This example returns " the " with a space before and after "the." The return string is everything after " is" and before "text." The startString " is" begins with a space; this prevents @Middle from returning a string that starts at the "is" in the word "This."
See Also