Skip to Content
Former Member
Aug 22, 2008 at 06:31 PM

Custom Record Sort?


I have a field that is a "String" and I need to sort it a special way. The data contains both numbers and words, and when I sort it using the record sort expert. I get the numbers to show up, then the words show up after all the number records have displayed.

I need to be able to put the word values in A-Z to display first. Then I will need to display the number values after all of the word values; and sort the numbers 1-9.

So restating my question: I need to see words values first, and when all of those records have been sorted. I will need to see the numbers start to sort below the word values. This is all in the same field.

How would I go about doing something like this?