AnsweredAssumed Answered

Sorting Text Fields Containing Both Text

Question asked by walrus28 on Jun 3, 2015
Latest reply on Jun 9, 2015 by raybaudi

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, multiple times (up to 5) 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 9 Pigs 39
  •      
  • 8,000 Dogs 55 Pigs 8
  •      
  • 8,000 Dogs 55 Pigs 39
  •      
  • 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