Sort by in expression list box

[#1]

Hi,

My list box is concatination of Numeric and text values Like:

5689-anvfgh

1002-gjkhk

455565656-tyhkjljkl

How can i do sort by A-Z on text value?

[CELAMBARASAN]

Hi,

Use sort by expression as

=SubField(FieldName,'-',2)

[MayilVahanan]

HI

PFA

Edit:

Yes, Celambarasn gave the result .. sorry i didn't notice it.

[#4]

pl see above img.

My Expression is Numerber &'-'& Text

i want to sort all tezt by A-Z regardless od numeric value

[MayilVahanan]

HI

Can you post a sample file? Its helps to find a solution

[oscar_ortiz]

Why not take care of this in the laod script.

Load

     NumField & '-' & TextField as Field1,

     NumField,

     TextField,

     "

     "

     "

Then in your list box select the concatenated field Field1 as your dimension.  In the sort tab use the TextField in the expression to use that as the sorting field.

Good luck

Oscar