Problem with sorting in list box!

[#1]

Hi All

I have given the scenario below.

Before using the expression in one of my list box it was displaying as shown below which was expected.

A A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12

As I wanted to filter A from above list box. I used the expression as if(fieldname<>A,fieldname)

A1 A10 A11 A12 A2 A3 A4 A5 A6 A7 A8 A9

May I know how to sort that so that it displays as expected(Shown below).

Thanks

Attitude

[#2]

Hope you are looking for the sort order

A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12

properties->sort-> expression->ascending

Give the expression as

=Replace(fieldname,'A','')

I think this would work out. Not sure if there is a better way ..

Regards

DS

[its_anandrjs]

Hi,

Hope you got any solution if not let me know about that or share any sample file.

Rgds

Anand

[kaushiknsolanki]

Hi,

    Have a look at the example file.

Regards,

Kaushik Solanki