Alphabetical Sorting Order

Options
user04669
user04669 Member
in Archive

What is the exact logic of the alphabetical sorting on fields?  I have a field called advertiser and find that it's sorting by upper case, sentance case then lower case.  Is this what it's doing??  I need it to sort alphabetical regardless of case.

Comments

  • PodiumMason
    PodiumMason Contributor
    Options

    Hi @user04669!

     

    That is likely what's happening here, is that it's sorting cases in addition to alphabeticals. 

     

    What you can do as a possible fix for this is to create a simple beast mode that looks like this:

     

    LOWER(`Your Column Here`)

     

    Then go ahead and sort by the newly created beast mode and see if that fixes the sort issue. 

     

    Hope this is helpful!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
This discussion has been closed.

Categories