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?