Hi
I have a house number field that contains stringbased data like 1,2A,3,3B,10,100A.
Right now it is a basic textfield and it does string sorting, which is not working for me.
I need it to sort numerically and then alphabetically on the field.
How can I best achieve that ?
HI @Nicolai_Jee
Are there any restrictions? Can you manipulate the data before indexing?
I imagined adding two fields one for the number and one for the letter and sort using multilevel.