I'm trying to make a solution with clairvoyance like the on from John Mark Osborne, it just doesn't work, i have attached the file i made if someone could tell me what i'm doing wrong.

test.fp7.zip

For starters you are complicating your life. Use a custom function to explode you text. Here's my version of it.

/*

 Name: TypeAhead

Params: text

Function:

*/

/*Builds a multi-line key that can be used in relationships using recursion*/



Let 

(

     x = Length ( text );



     If ( x > 0; 

          Left ( text ; x ) 

          & "¶" & 

         TypeAhead ( Left ( text ; x - 1 ) ) 

     )

)

/* Notes: Rob Poelking */

 

and this one 

/*

 Name: TypeAheadWords

Params: text

Function:

*/

/*Builds a multi-line key that can be used in relationships*/



Substitute ( text ; " " ; ¶ )  & ¶

/* Notes: Rob Poelking */

Now you've got your calc unstored--your relationship will never work until you store it.

You're doing text functions and returning it as a number. Return text and follow it by a "*" or some other text identifier rather than a number.

test.fp7.zip

Edited August 19, 200817 yr by Guest