Explode ( separator ; text ; limit )
Split a string by a string - inspired by similar text parsing functions
Be the first to rate this function Log in to vote
Chris Irvine - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Inspired by the capability of the famous PHP function by the same name.
This is useful if you need to process a string which is delimited by comas, pipes, tab, or any other character. Quickly pivot that string into a value list which is then easy to access with the GetValue family of built-in functions.
The optional limit argument can enhance behavior and shave off unnecessary work. Further examples can be found in script comments.
Jul 22, 2022
|Does this only work if the field calculation is unstored?|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.