View Single Post
  #1   Report Post  
MrTown MrTown is offline
Junior Member
 
Posts: 1
Default Sort by placement value from left to right & adding trailing zeros for short

How can I create a sort with helper columns or some other methods to achieve the following?
I would like to sort by evaluating each placement value from left to right and place them in descending order as if they are all the same length of character string... I have tried many helper columns but can't sort exactly as needed.

I would like to turn this:

1200
1205
1210
1211
1215
1218
1225
1245
1060-5
114-0-01
114-5-01
115-3-01
116-3-02
116-5-02
117-0-02
117-5-02
120-3-01
120-5-01
121-0-01
121-5-01
1225-3
123-0-01
123-5-01
124-0-01
124-5-01




INTO THIS, once sorted:

1060-5
114-0-01
114-5-01
115-3-01
116-3-02
116-5-02
117-0-02
117-5-02
120-3-01
120-5-01
1200
1205
121-0-01
121-5-01
1210
1211
1215
1218
1225
1225-3
123-0-01
123-5-01
124-0-01
124-5-01
1245




Thank you!!!