How do I sort a text field from right to left?
Want to sort 14054.0, 14054.1, 14054.2........ 14054.10 but it is sorting as 14054.0, 14054.1, 14054.10, 14054.2
Forum Discussion
Not tested buy try this as a sort field. You do not need to display it on the report, just sort on it. This is a formula text field type
var text LeftOfDecimal = Left([my field],".");
var text RightOfDecimal = IF(Contains([my field],"."), Right([my field],".");
var text NewRightOfDecimal = Right("000" & $RightOfDecimal,3);
If(Trim([my field]<>"", List(".", $LeftOfDecimal, $NewRightOfDecimal)
If there are any syntax error or problem, please post your code and the error message as this was not tested.
var text LeftOfDecimal = Left([my field],".");
var text RightOfDecimal = IF(Contains([my field],"."), Right([my field],".");
var text NewRightOfDecimal = Right("000" & $RightOfDecimal,3);
If(Trim([my field]<>"", List(".", $LeftOfDecimal, $NewRightOfDecimal)
If there are any syntax error or problem, please post your code and the error message as this was not tested.