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
Post a Comment