Brian Dunning's FileMaker Custom Functions

GetWord ( text ; number )

Get a specified single word from a string

  Average rating: 4.5 (34 votes) Log in to vote

David Head   David Head

Share on Facebook Share on Twitter

  Sample input:
GetWord ( "This is a string" ; 2 )
  Sample output:

  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 )



Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.