FileMaker Pro Custom Functions

"List" is now a built in function so the "list" parameter needs to be edited and given a different name.

The same applies to MinValue and MaxValue custom functions.

Thanks for the work though. It solved mt little problem!!

David, Sydney
April 02, 2009 3:47am

/* --------------------------------------------------------------------------- -----
Returns the list with items sorted

Syntax: SortValues ( lst ; sortAscending )
In: lst - the return delimited list to search
sortAscending - if True (1), the list will be sorted Ascending,
if False (0), the sorting is Descending

Return type: Text

SortValues ( "apple¶grape¶banana" ; True ) --> "apple¶banana¶grape"
SortValues ( "apple¶grape¶banana" ; False ) --> "grape¶banana¶apple"

This sort uses functions MinValue() and MaxValue()

Theo Ros
---------------------------------------------------------------------- ---------- */

If ( ValueCount ( lst ) ;
// first make sure that the lowest or highest value and the list itself end with return
Let ( [ val = If ( sortAscending ; MinValue ( lst; "" ) ; MaxValue ( lst ; "" ) ) & "¶" ;
lst = If ( Right ( lst ; 1 ) <> "¶" ; lst & "¶" ; lst ) ;
// find and replace just 1 occurrence of the found value
rest = Replace ( lst ; Position ( lst ; val ; 1 ; 1) ; Length ( val ) ; "" ) ] ;
// finally remove any leading or trailing returns from the list
LeftWords ( val & SortValues ( rest ; sortAscending ) ; 999999999 )
)
)

Vaughan, Sydney, Australia
August 22, 2011 10:56pm