lotus notes - Dialog List values to sort in ascending order -


i in need of help. have dialog list return elements in selectionlist following:

grade 10a grade 10b grade 11a grade 8 grade 9h

@return(@trim(@sort(@unique(selectionlist);[ascending] )))); "")

i want them show them in following manner: grade 8 grade 9h grade 10a grade 10b grade 11a

any suggestions formula in @return used?

thank you!

sort number (max. 2 digits):

_list := @unique(selectionlist); _numberlist := @right("00" + @text(@tonumber(@right(_list; "grade "))); 2); @return(@right(@sort(_numberlist  + "#" + _list); "#")) 

keep in mind functions @prompt([okcancellist]; ...) sort list on own , resort (=ruin) sorted list.

example:

if _list is
grade 10b
grade 11a
grade 10a
grade 8
grade 9h

then _numberlist be
10
11
10
08
09

@sort() parameter
10#grade 10b
11#grade 11a
10#grade 10a
08#grade 8
09#grade 9h

@right() parameter
08#grade 8
09#grade 9h
10#grade 10a
10#grade 10b
11#grade 11a

and @return() return
grade 8
grade 9h
grade 10a
grade 10b
grade 11a


Comments

Popular posts from this blog

angular - Ionic slides - dynamically add slides before and after -

minify - Minimizing css files -

Add a dynamic header in angular 2 http provider -