I have a hierarchy of items.
Each level of the hierarchy has a reference number,
which is a Text type column, so for instance 2.5.4.7 or 10.2.4.3
My problem is using these numbers to sort in a table view.
The sort will put a ‘10’ before a ‘2’ or a ‘9’, etc, so
1.5.20.4 10.8.8.4 2.4.21.3
instead of
1.5.20.4 2.4.21.3 10.8.8.4
I couldn’t find anything on this in the documentation or forum.
Does anyone know a way to achieve a ‘numeric’ sort on ‘text’ numbers?
Thx
LinkedIn
Twitter
