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.
@Middle("North Carolina";4;3)
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.
@Middle("North Carolina";4;-3)
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.
@Middle("North Carolina";" ";3)
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.
@Middle("North Carolina";"th";-2)
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."
@Middle("This is the text"; 4; "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."
@Middle("This is the text"; " is"; "text")
7. This example returns "Hello" and "This" in a list. The offset is the beginning of each text element and the end text is the first space.
@Middle("Hello world" : "This is the time"; 0; " ")
See Also
@Middle
Glossary
Feedback on
Help
or
Product Usability
?
Help on Help
All Help Contents
Glossary