text sort

Replies to This Discussion

Permalink Reply by Arend on June 8, 2015 at 10:56am

It's not a cultural thing. You want to combine two sorts of sorting. You want the first 5 characters to be sorted as text, and the numbers to be interpreted as a number. The easiest way to solve it is to use trailing zero's, eg:

TS A.01

Permalink Reply by Joe Allberry on June 8, 2015 at 11:11am

There may be a slightly more succinct way of achieving this, but this gets you there:

Attachments:

• 150608 GH List Text Sort.gh, 6 KB

Permalink Reply by Joe Allberry on June 8, 2015 at 11:16am

Actually, nicer with it all in the one expression component "Left(x,y)&Format("{0:0#}",Int(Right(x,Length(x)-y)))":

Attachments:

• 150608 GH List Text Sort v2.gh, 7 KB

Permalink Reply by Joseph Oster on June 8, 2015 at 12:16pm

Sweet!  And sweeter still if you pass the "values" along and display them, using 'V':

Permalink Reply by bea franko on June 9, 2015 at 1:27am

thanks a lot guys!!!