LeftSeparator ( text ; seperator ; occurrence )
Returns the characters in text counting from the left to the specified occurrence of the separator.
Average rating: 3.9 (34 votes) Log in to vote
|
Kurt Otto - Show more from this author
ottopiaDESIGN http://ottopia.dyndns.org/ |
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Format
------
LeftSeparator ( text ; seperator ; occurrence )
Parameters
----------
text - any text expression or text field.
separator - any text expression or text field representing the set of characters you want to find.
occurrence - any numeric expression or field containing a number, representing which instance of the text string you want to find.
Data type returned
----------------
text
Description
----------
Returns the characters in text counting from the left to the specified occurrence of the separator.
Examples
--------
LeftSeparator ( "aaa:bbb:ccc" ; ":" ; 1 ) returns aaa
LeftSeparator ( "aaa:bbb:ccc" ; ":" ; 2 ) returns aaa:bbb
LeftSeparator ( "aaa:bbb:ccc" ; ":" ; 3 ) returns ""
Comments
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.