Re: Sort results based on alpha at first

Hi Thamizh You can add a field to the index that acts as a "sortable flag" with e.g. 0 for alpha, 1 for numerical, and 2 for other first character. Then you can sort on both fields, listing the "flag" field first. Thomas Op zo 29 aug. 2021 20:09 schreef : > Hi, > > > > We need to sort the resul

Re: Sort results based on alpha at first

On 8/29/2021 12:09 PM, post.ta...@gmail.com wrote: We need to sort the results based on alphabetic followed by numeric. Something like below Expected results order: Abctext Bbctext Cbctext 1test 2test 3test This is contrary to all the "natural" sort ordering available in modern programmin

Sort results based on alpha at first

Hi, We need to sort the results based on alphabetic followed by numeric. Something like below Current results order: 1test 2test 3test Abctext Bbctext Cbctext Expected results order: Abctext Bbctext Cbctext 1test 2test 3test Please help me to achieve the result ordering