FileMaker Pro Custom Functions

The script does not work properly when the third parameter>1. Take the example above:
WordPosition ( "this may be or may be not the best way" ; "be" ; 2;1 )
return 4;
When the third parameter is 3, 4, 5, ... the result is 5, 6, 7,...

It seems to me there are probably two solutions for it (1) write a subCF, which is recursive and takes 5 parameters: the fifth will be constant number equal to the initial third parameter; (2) the easy solution, delete the third parameter and make it default value 1.

Lizhe Xu, East Lyme, CT
August 26, 2009 7:29am

After second thought, the second solution indeed is not so easy, it is still need a subCF, which will accept 4 parameters. I now use your CF in my solution but with the constant value 1 for the third parameter.

Lizhe Xu, East Lyme, CT
August 26, 2009 7:38am

I have fixed the problem Lizhe brought up, and I also added support for a negative value for occurrence.

Let(
[
count = WordCount( text );
direction = Sign( occurrence );
startWord = MiddleWords( text; start; 1 )
];
Case(
start < 1 or start > count;
0;
IsEmpty( text ) or IsEmpty( searchWord ) or IsEmpty( start ) or IsEmpty( occurrence );
"";
startWord ≠ searchWord;
WordPosition( text; searchWord; start + direction; occurrence );
startWord = searchWord and Abs( occurrence ) ≠ 1;
WordPosition( text; searchWord; start + direction; occurrence - direction );
start
)
)

Max Heller, Frederick, MD
April 13, 2010 4:04pm