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
Numerically speaking, 14054.1 is the same as 14054.10 or 14054.100. The trailing zeroes does not change the value. Now, if you already have the value, and you sort them based on that number, they will appear together. I have another question: What do you mean "14054.10 document?" Can you provide more context?
- Marlene has a document numbering system where say the versions are indicated by the suffix.
So the original is version 0, then it counts up to .1, and then .2 and eventually to .10 where 10 is after 2.
