WordPosition ( text ; searchWord ; start ; occurrence )

Position Function for words

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

Max Heller - Show more from this author
fmax software

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)

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

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

Comments

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

WordPosition ( text ; searchWord ; start ; occurrence )

Comments

Support this website.

Support this website.