NumberLines ( Text ; Format_abc|123|PrefixChar ; suffix ; n ; result%

Recursive custom function that will return a delimted list with character or pattern you specify

Average rating: 4.2 (38 votes) Log in to vote

Alex Babkov - Show more from this author
Real Evolution
www.realevolution.com.au

Sample input:

NumberLines( "Celery¶Popsicle¶Coke¶Ice Cream" ; "abc" ; ") " ; "" ; "" )

Sample output:

a) Celery
b) Popsicle
c) Coke
d) Ice Cream

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

Let([ 
n = n + 1 ;
x = 
Case(
Format_abc|123|PrefixChar = "abc" ; 
Case( n = 1 ; "a" ; n = 2 ; "b" ; n = 3 ; "c" ;n = 4 ; "d" ; n = 5; "e" ; n = 6 ; "f" ;n = 7 ; "g" ; n = 8 ; "h" ; n = 9 ; "i" ; n = 10 ; "j" ; n = 11 ; "k" ; n = 12 ; "l" ;n = 13 ; "m" ; n = 14; "n" ; n = 15 ; "o" ;n = 16 ; "p" ; n = 17 ; "q" ; n = 18 ; "r" ; n = 19 ; "s" ; n = 20 ; "t" ; n = 21 ; "u" ;n = 22 ; "v" ; n = 23; "w" ; n = 24 ; "x" ;n = 25 ; "y" ; n = 26  ; "z") ;
Format_abc|123|PrefixChar = "123" ;
n ;
//Just prefix the character(s) specified if not abc or 123
Format_abc|123|PrefixChar );
result = result & If( n <> 1 ; ¶ ) & x & suffix  & GetValue( Text ; n ) 
];

If( n >= ValueCount( Text ) ; 
If( ValueCount(Text) <> 0 ; result) ;
NumberLines( Text ; Format_abc|123|PrefixChar ; suffix ; n ; result )
)
)

I find this useful when presenting lists in custom dialogs and having the user select a particular value in that list -- prefixing a number pattern of 1, 2, 3 or a letter pattern of a, b, c makes it much easier for them to pick out particular items.

Specifying "abc" as the Format will return a list of up to 26 values -- prefix, only. Specifying "123" will return any number of values in the list. Specifying any other character(s) will return that list with the character prefixed.

As for the name, i couldn't think of anything else -- and the % at the end should be a ")" not sure what's going on there.

Comments

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

NumberLines ( Text ; Format_abc|123|PrefixChar ; suffix ; n ; result%

Comments

Support this website.

Support this website.