Sorting a house number field

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.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.