text sort

by bea franko

Jun 8, 2015

hey guys!

how to set up the right culture in the text sort component to sort the text right.

here is a picture of my wrong result:

i want to have the text sorted like this:

TS A.1

TS A.2

TS A.3

...

TS A.10

TS A.11

TS A.12

TS B.1

TS B.2

TS B.3

...

TS B.10

TS B.11

TS B.12

any ideas how to solve this problem?

thanks a lot!

bea

  • up

    Arend

    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

    3

    Jun 8, 2015

    • up

      bea franko

      thanks a lot guys!!!

      Jun 9, 2015