v119 and numeric sorting (OpenInsight Specific)
At 24 JUN 1998 11:51:03AM Jacob Ignatius wrote:
Is it possible for v119 to do a numeric sort on a field in the dynamic array given? I have a numeric field which I would like to be ordered in ascending numeric order.
At 24 JUN 1998 01:52PM Andrew P McAuley wrote:
To quote the on-line help (type in V119 in the system editor and press F1)
JUSTS Works the same way as BYS but refers to the justification of each sort field and consequently whether an alpha or numeric sort is performed. L and R are the only valid characters representing left and right justification, respectively.
World Leaders in all things RevSoft
At 25 JUN 1998 03:41AM Jacob Ignatius wrote:
When I use left (L) justification to sort the numeric field I get values for that as given below :
1004
1004
1006
1008
1009
101
1015
102
111
2456
Not exactly numeric sorting.
At 25 JUN 1998 05:11AM Andrew P McAuley wrote:
L and R are the only valid characters representing left and right justification, respectively
Sorry Jacob, I forgot where you were you were coming from.
In computing, a left justified sort is used for alpha characters and a right justified sort is used for numeric. So in this instance you use an R not an L.
World Leaders in all things RevSoft
At 25 JUN 1998 05:31AM Jacob Ignatius wrote:
Thanks Andrew. This does the trick.