Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.
Sort Array
I have large tables which I am sorting, with some columns numeric, and using AR sorts.
The data however has a mixture of integer and non-integer, and this causes the right-aligned sort to fail.
Example below, I would expect the sort to be in order : 0.5 > 1 > 2
It seems to be length based, ie AL.
Any ideas?
DEBUG
SF_TABLE=""
SF_TABLE<1,1>="AA" ;SF_TABLE<2,1>="2"
SF_TABLE<1,2>="BB" ;SF_TABLE<2,2>="1"
SF_TABLE<1,3>="CC" ;SF_TABLE<2,3>="0.5"
SEQ="AR2"
SF_TABLE=SRP_Array("SortRows",SF_TABLE,SEQ)
RETURN 0
The data however has a mixture of integer and non-integer, and this causes the right-aligned sort to fail.
Example below, I would expect the sort to be in order : 0.5 > 1 > 2
It seems to be length based, ie AL.
Any ideas?
DEBUG
SF_TABLE=""
SF_TABLE<1,1>="AA" ;SF_TABLE<2,1>="2"
SF_TABLE<1,2>="BB" ;SF_TABLE<2,2>="1"
SF_TABLE<1,3>="CC" ;SF_TABLE<2,3>="0.5"
SEQ="AR2"
SF_TABLE=SRP_Array("SortRows",SF_TABLE,SEQ)
RETURN 0
Comments
"AN" works fine.
This is a failure by me to read the online help :(