Sorting a house number field

Elastic Stack Elasticsearch
1

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 ?

2

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.

3

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