Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   Crossplatform   Server (Not)   Client   Components   Old   Guides
New in version: 5.0   5.1   5.2   5.3   5.4   6.0   6.1   6.2   6.3   6.4   6.5   7.0   7.1    Statistic  


Sorts the list.

Component: List
Version: 4.2
Mac OS X: Yes
Windows: Yes
Server: Yes
FileMaker Cloud: Yes

MBS( "List.Sort"; List { ; Flags; NoReturnEnding } )


Parameter Description Example value
List The list to sort. "Hello" ¶ "World"
Flags Optional
Optional, whether to sort case insensitive or descending.
Pass 1 to sort case insensitive or 0 to sort case sensitive.
Add 2 to sort descending.
Add 4 for sorting dates in DD.MM.YYYY style and 8 for sorting dates in MM.DD.YYYY style.
NoReturnEnding Optional
Pass 1 to have no extra newline character on the end of the returned list. Default is 0 to include one to easily concat lists.


Returns new list.


Sorts the list.
Version 6.2 adds new modes for date sorting. Mode 4 for DD.MM.YYYY style and mode 8 for MM.DD.YYYY style.


Sort case sensitive:

MBS( "List.Sort"; "Hello¶World¶Test" )

Sort case insensitive:

MBS( "List.Sort"; "Hello¶World¶test"; 1 )

Sort case sensitive and descending:

MBS( "List.Sort"; "Hello¶World¶Test"; 2 )

Sort case insensitive and descending:

MBS( "List.Sort"; "Hello¶World¶test"; 3 )

Sort German dates:

Show Custom Dialog [MBS("List.Sort"; "01.01.2001¶12.04.1981¶01.04.1981¶12.07.1981¶12.01.1981¶23.11.2014"; 4; 0)]

Sort US dates:

Show Custom Dialog [MBS("List.Sort"; "01/01/2001¶04/12/1981¶04/01/1981¶07/12/1981¶01/12/1981¶11/23/2014"; 8; 0)]

See also

List.SetValue   -   List.ValueIndex

Feedback: Report problem or ask question.

MBS FileMaker Plugins - Pfarrgemeinde St. Arnulf Nickenich