GetWord ( text ; number )
Get a specified single word from a string
Average rating: 4.5 (34 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
While FileMaker provides the LeftWords, MiddleWords and RightWords functions to extract single words and word strings, more often than not I find myself wanting one word only from a string. This custom function makes it easier to extract a single word and makes it easier to read and understand what is being done.
For example, it is easier to read and understand:
GetWord ( address ; 3 )
MiddleWords ( address ; 3 ; 1 )
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.