SortValues2

Sorts the values in a list ascending or descending.

Average rating: 4.9 (23 votes) Log in to vote

Joshua Paul - Show more from this author
Neo Code
http://www.neocode.com

Sample input:

SortValues ( "apple¶grape¶banana" ; True )

SortValues ( "apple¶grape¶banana" ; False )

Sample output:

apple¶banana¶grape

grape¶banana¶apple

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

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

Syntax: SortValues ( lst ; sortAscending )
In: lst - the return delimited lst to search
     sortAscending - if True (1), the lst 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 lst 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 lst
    LeftWords ( val & SortValues ( rest ; sortAscending ) ; 999999999 ) 
  )
)

NOTE this function written by Theo Ros, this version replaces "list" with "lst"

Returns the list with items sorted

Syntax: SortValues ( list ; sortAscending )
In: list - 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()

Comments

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

SortValues2

Comments

Support this website.

Support this website.