Sorting TextList in formula

Question

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
------------------------------

markshnier__you · Answer

What is the source of the text list?&nbsp; Is it a multi select field?&nbsp; 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 · Answer

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 · Answer

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
------------------------------

mikefreyder · Answer

Not to hijack the thread, but I just encountered the same need and my text list source is the result of a Formula Query which does appear to be sorted by Record ID#.------------------------------Mike Freyder------------------------------

joelhickok · Answer

I have the same need as well.&nbsp; Based on my investigation, this is not possible in a Formula.&nbsp; If you have figured out a solution, please share, but it really does not seem possible at this time.&nbsp; 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.&nbsp; Still a very good product!

Forum Discussion

Sorting TextList in formula