Order Values in ListBox

[#1]

Hello,

I have a ListBox where there are the following values:

0<X<2

2<X<4

4<X<6

6<X<8

The thing is that when I show those values, they show differently, and I've tried different ways (Number, Text, Load Order).

Do you know how could I order them?

Thank you!

[veidlburkhard]

Hi Mart,

Sorting by 'Text' is the right answer see the picture below:

Hope this helps

Burkhard

[#3]

Thanks! And what if I have the value: X>8? Is there any way to order that one?

Because it appears as the first value when I order them.

[veidlburkhard]

Hi Mart,

I tested it and it worked well with sorting by 'Text'. See the picture

You should be aware not to have a space in front of the X, though...

Hope this helps

Burkhard

[sasikanth]

Try to use Match() function in Sort tab--->Expression

lsome thing like

=Match(<Filed-name>,'0<X<2','2<X<4','4<X<6','6<X<8')

Hope it will help