How to sort list box with an expression

[cliff_clayman]

I have a list box that has some blanks in it, so I used an expression to remove them.  Upon doing so, the sort no longer works as it did previously.  I want to sort ascending.  I tried changing the sort from State - Auto Ascending to Expression - Ascending and then placing the expression in the box below, but it does not seem to work.  Here is the expression I am using:

=If(Len(Buyer)>0,Buyer)

[sunny_talwar · Accepted solution]

Try this:

=If(Len(trim(PurgeChar(Buyer, Chr(48))))>0, Buyer)

[cliff_clayman]

What does that do exactly?

[sunny_talwar]

There are two types of blanks.... one is normal blank and the other one is some sort of character which seems to be Chr(48).... I purged it while checking for blanks

[cliff_clayman]

Great, thanks again!!!