Skip to content

Sort str

mtbeek32 edited this page Jan 2, 2023 · 4 revisions

title: Sort str permalink: /Sort_str/

String functions sort_str(ing)

syntax

  • sort_str(string_dataitem)

definition

sort_str(string_dataitem) sorts data item string_dataitem in ascending order (ASCII sort sequence).

description

The sort_str function is case sensitive.

Use the reverse function on a sorted string to sort in descending order (see example).

applies to

example

attribute sortA_asc  (ADomain) := sort_str(A);  attribute sortA_desc (ADomain) := reverse(sortA_asc);

A sortA_asc srtA_desc
'Test' ' test met spatie' 'twee woorden'
'88hallo99' '+)' 'Test'
'+)' '88hallo99' '88hallo99'
'twee woorden' 'Test' '+)'
' test met spatie' 'twee woorden' ' test met spatie'

ADomain, nr of rows = 5

see also

Clone this wiki locally