AnsweredAssumed Answered

Sorting Text Fields Containing Both Text

Question asked by walrus28 on May 26, 2015
Latest reply on May 30, 2015 by walrus28

Title

Sorting Text Fields Containing Both Text & Numbers

Post

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
  •      
  • 24/7
  •      
  • 80 Dogs
  •      
  • 500 Dogs
  •      
  • 8,000 Dogs
  •      
  • Comin' @ You
  •      
  • Comin' 4 You
  •      
  • Cool Train 9
  •      
  • Cool Train 387
  •      
  • Pizza
  •      
  • 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.)

Outcomes