PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Effect of ListSort
  • Comparing numeric values
  • Characters taken into account for punctuation and spaces
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Sorts the elements found in a memory List Box, ListView or Combo Box control. This function has no effect on the browsing List Box, ListView and Combo Box controls.
Remark: This function is useless if the control was declared as "Sorted" in the control description window ("Details" tab).
Versions 16 and later
WINDEVLinux This function is now available for WINDEV applications in Linux.
New in version 16
WINDEVLinux This function is now available for WINDEV applications in Linux.
WINDEVLinux This function is now available for WINDEV applications in Linux.
Versions 17 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Example
// Sorts the List Box control in lexicographical order
ListSort(LIST_Customer, True, ccLexicographicOrder)
Syntax
ListSort(<List Box control> [, <Sort order> [, <Sort options>]])
<List Box control>: Control name
Name of List Box or Combo Box control to sort.
<Sort order>: Optional boolean
  • True (by default) to perform a sort in ascending order,
  • False to perform a sort in descending order.
<Sort options>: Optional constant (or combination of constants)
Sort options selected for the content of List Box (or Combo Box) control:
ccLexicographicOrderSorts the strings in lexicographical order (for example, 'é' is between 'e' and 'f).
ccNormalSort while performing a standard comparison, similar to the = operator =.
ccRespectNumericSort while taking into account the numeric values inside the strings (in this case, "10" comes after "9").
ccIgnoreAccentSort while ignoring the accented characters
ccIgnoreCaseSort while ignoring the case (uppercase/lowercase characters).
ccIgnoreSpaceSort while ignoring the space characters found before and after the character strings.
ccIgnorePunctuationAndSpaceSort while ignoring the punctuation and the space characters (for more details, see the Notes)
sortDefault
(default value)
Performs a case-insensitive and accent-insensitive sort. Ignores spaces.
sortWithoutFunctionGxxxSorts elements while ignoring gImage, gStoredValue, etc., ... By default, these elements are taken into account by the sort.
Remarks

Effect of ListSort

ListSort will have an effect at a specific moment: after calling ListSort, elements will be added to the List Box or Combo Box control according to the sort options defined in the control description window.

Comparing numeric values

The ccRespectNumeric constant sorts by taking into account the numeric value represented by digits and not just the alphabetical order of the numbers.
Without the ccRespectNumeric constant, the strings below will be sorted in the following order: "string1", "string10", "string2"
With the ccRespectNumeric constant, the same strings will be sorted in this order: "string1", "string2", "string10"
Lets' see some examples of comparison performed with and without the ccRespectNumeric constant:
Sorting strings containing digits without the ccRespectNumeric constantSorting strings containing digits with the ccRespectNumeric constant
000
000
001001
00901
011
010009
0909
19
10010
1110
911
Sorting strings containing digits without the ccRespectNumeric constantSorting strings containing digits with the ccRespectNumeric constant
10.00Aa7.00Aa
10.01Gh7.01Ba
10.50Ag7.01Dfe
11.00Aa7.50Fg
7.00Aa7.51Tga
7.01Ba8.00Aa
7.01Dfe8.01Gjk
7.50Fg8.01Ty
7.51Tga8.50Ze
8.00Aa9.00Aa
8.01Gjk9.80Er
8.01Ty9.99Zaaa
8.50Ze10.00Aa
9.00Aa10.01Gh
9.80Er10.50Ag
9.99Zaaa11.00Aa

Characters taken into account for punctuation and spaces

The characters taken into account for punctuation and spaces are provided by the system. To get the list of these characters, write the following WLanguage code:
s is string
FOR i = 0 TO 255
IF Charact(i) <> StringFormat(Charact(i), ccIgnorePunctuationAndSpace) THEN
 s += Charact(i)
END
END
Info(s)
ToClipboard(s)
Component: wd270obj.dll
Minimum version required
  • Version 12
This page is also available for…
Comments
Click [Add] to post a comment