Forum Discussion

SaarLitman1's avatar
SaarLitman1
Qrew Member
3 years ago

Sorting TextList in formula

Any option to sort a Text list with words in alphabetical order? 

I need to sort something like this: BB;CC;AA;DD;EE;GG;FF to AA;BB;CC;DD;EE;FF;GG in a formula.

I'm currently looking at using Part to break the list into individual elements then use Min to look for the elements and extract the first word, but then I need to recreate the list minus the word I already found, this need to happen for every word (max 20)
I'm already in like 40 with no end in sight

Am I on the right track? 
Any help will be appreciated.

------------------------------
Saar Litman
------------------------------
Formulas and functions

7 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    What is the source of the text list?  Is it a multi select field?  or a combined text Summary or the result of a Formula Query - I'm thinking the latter which is sorted by Record ID#.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • SaarLitman1's avatar
      SaarLitman1
      Qrew Member
      3 years ago
      The source is a combination of 2 text fields in the same record,
      I SearchAndReplace([Name]& " " &[Description]," ",";") and then need to sort the words alphabetically. 



      ------------------------------
      Saar Litman
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        3 years ago
        I guess I am not understanding. How do you get that long text string.  So there is no relationship and not a combined text summary field?

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------
  • JoelHickok's avatar
    JoelHickok
    Qrew Cadet
    2 years ago
    I have the same need as well.  Based on my investigation, this is not possible in a Formula.  If you have figured out a solution, please share, but it really does not seem possible at this time.  None of the existing Formula functions offer the tools to sort.

    For how powerful Quickbase is, there are always very obvious holes in the product and chinks in the armor.  Still a very good product!
    • SergioSanchez1's avatar
      SergioSanchez1
      Qrew Trainee
      2 years ago

      Hi Joel

      Any luck with a solution for this? :) I am facing the exactly same situation.... 



      ------------------------------
      Sergio Sanchez
      ------------------------------
      • JoelHickok's avatar
        JoelHickok
        Qrew Cadet
        2 years ago

        No luck.  They almost give you the tools to do this in a Formula field.  But not quite.