TrimAt ( text ; delimiter ; occurrence )
returns all text preceding the specified occurrence of the specified delimiter
Be the first to rate this function Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This function acts like Left, but uses the Position of the specified delimiter as a point of reference. If the occurrence parameter is:
• a positive integer, the value returned will be all characters preceding that occurrence of the delimiter, moving forwards from the first character of the original text.
• a negative integer, the value returned will be all characters preceding that occurrence of the delimiter, moving backwards from the last character of the original text.
• Any other value returns an empty string.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.