Forum Discussion

JonathanHeuer's avatar
JonathanHeuer
Qrew Cadet
4 years ago

Re: Find position of text string in larger string

Thanks Mark, I like this approach. The problem is that the length of the array in the summary text field is arbitrarily long; that is, it may well have more than 26 elements in it.

------------------------------
Jonathan Heuer
------------------------------

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Well there is no limit to the length of a formula 


    var text AA = Trim(Part($value,27,";"));
    var text AB =Trim(Part($value,28,";"));
    var text AC = Trim(Part($value,29,";"));
    etc.

    just make the formula longer, for the largest number of practical elements, say 100?  Whatever,  it's just copy and paste to make the formula longer.




    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------