SplitWord ( Text ; count )

This function split like left pyramid structure,it always takes the count parameter as 0.

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

Abhaya Ku.Behera
MFS
http://mindfiresolutions.com

Sample input:

SplitWord( "user" ; 0)

Sample output:

u
us
use
user

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

Let ([txt=Text;
        count=count+1;
        total1 = Length ( txt );
        final=Left ( txt ; count )
        ];

If (count<total1; final &"¶"  & SplitWord(Text;count) ; final)

 )

It takes the given text and count as 0 at initially.
define all variable with its proper value and evaluate the function by recursivelly.
Each recursive function takes the update count value evaluated at each step(default value is 0)

Comments

		Jake DeGroot Oct 2, 2012
thanks this is very useful

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

SplitWord ( Text ; count )

Comments

Support this website.

Support this website.