Re: Sorting on Alphanumeric order

Home Forum Reporting Sorting on Alphanumeric order Re: Sorting on Alphanumeric order

#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.