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