Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
properties->sort-> expression->
wildmatch(col,'A1', 'A10' ,'A11', 'A12', 'A2' ,'A3', 'A4', 'A5', 'A6', 'A7', 'A8', 'A9')
Hi,
Use this
Mid(YourField,2,Len(Yourfield)-1)
and paste this code in Sort by expression.
Rgds
Anand
Or in place of that you may use
Properties -> Sort by -> Expresion
Match(col,'A1', 'A2' ,'A3', 'A4', 'A5', 'A6', 'A7', 'A8', 'A9','A10' ,'A11', 'A12')
Or
Thanks!
Yes I did that before. But I have somewhere that it can be achieved without the use of wlidmatch? Any guesses???
So can it be achieved without the use of wildmatch?
You can use this and paste this code in
=Mid(fieldname,2,2)
If you want to filter A from list use
=If ( Len( fieldname ) > 1 , fieldname )
And to sort use
wildmatch --> Not sorting properly when related values are not there in the list box which is relation to the selection.
Mid(YourField,2,Len(Yourfield)-1) --> Not sorting properly when related values are not there in the list box which is relation to the selection.
Mid(fieldname,2,2) --> Not working as expected!
This sorting you are apply on the list box.
state-> ascending
