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 space, "is the," space. 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 space, "the," space. The return string is everything after "is" and before "text."
@Middle("This is the text"; "is"; "text")
See Also
@Middle
Glossary
Feedback on Help?
Help on Help
Open Full Help Window
Glossary
Feedback on Help?
Help on Help
Open Full Help Window