Sorting Text Fields Containing Both Text & Numbers
I have a text field called item_name that contains names on product packaging.
I would like to sort my records based on this field. I would like it to sort as text, but to sort numbers as numbers, even when the numbers are part of a string of text.
Numbers can be present at the beginning, middle, end, or not at all.
Here are some sample entries in the order I would like to sort them.
- 5/1 Pens
- 80 Dogs
- 500 Dogs
- 8,000 Dogs
- Comin' @ You
- Comin' 4 You
- Cool Train 9
- Cool Train 387
- Real 70's Big
- Real 70's Small
- Real 600's
(I made up the names, but they follow the same patterns as the names actually in my field.)