Home › Forum › Reporting › Sorting on Alphanumeric order › Re: Sorting on Alphanumeric order
November 11, 2010 at 11:36 pm #5497
So your issue at this point is only with getting the sub text function to work like you need it to. As long as your new helper field contains the properly ordered numbers, your report will work fine.
The sub text1 function is a bit tricky. The start position will use that exact space. For example using “012345” the value for start position 1 is “1”. But the end position uses the space before that. For example using “012345” the value for end position 4 is “3”. This is actually going to get changed in a future release, but for now this is how it works.