Brian Dunning's FileMaker Custom Functions

WordPosition ( text ; searchWord ; start ; occurrence )

Position Function for words

  Average rating: 4.0 (31 votes) Log in to vote

Max Heller   Max Heller
fmax software

Share on Facebook Share on Twitter

  Sample input:
WordPosition ( "to be or not to be" ; "be" ; 1 ; 1 )
WordPosition ( "it is a mad mad mad mad mad world" ; "mad" ; 7 ; -2 )
WordPosition ( "hello world" ; "hello" ; 1; 2 )
  Sample output:
2
6
0

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Behaves like the position function, but goes by word position instead of character position.

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.