Apparently Multi Sort Array performs case-sensitve searches, unlike anything
else in 4D. This is certainly not documented. Try this:
-----------------------------------------------------
ARRAY TEXT(aHistIsbn;8)
ARRAY DATE(aHistDate;8)
aHistIsbn{1}:="abcde"
aHistIsbn{2}:="abcde"
aHistIsbn{3}:="Abcde"
aHistIsbn{4}:="aBcde"
aHistIsbn{5}:="abcDE"
aHistIsbn{6}:="ABCDE"
aHistIsbn{7}:="xyz10"
aHistIsbn{8}:="XYZ10"
aHistDate{1}:=!01/01/2016!
aHistDate{2}:=!02/01/2016!
aHistDate{3}:=!03/01/2016!
aHistDate{4}:=!04/01/2016!
aHistDate{5}:=!05/01/2016!
aHistDate{6}:=!06/01/2016!
aHistDate{7}:=!01/01/2016!
aHistDate{8}:=!02/01/2016!
MULTI SORT ARRAY(aHistIsbn;>;aHistDate;<)
-----------------------------------------------------
and you’ll get this:
abcde 2/1/16
abcde 1/1/16
abcDE 5/1/16
aBcde 4/1/16
Abcde 3/1/16
ABCDE 6/1/16
xyz10 1/1/16
XYZ10 2/1/16
------------------------------------------------
Richard Wright
DataDomain
[email protected]
------------------------------------------------
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
