Find position of text string in larger string
I have a long string in my Services table, the result of a Combined Text Summary field, each element takes the pattern V###-#### (where the number parts of the string are arbitrary length). For exampl...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI would approach this differently. I would use the part function in QuickBase to isolate the different elements and then use a case function to determine the result.
var text value = totext([my multi select field]);
var text A = Trim(Part($value,1,";"));
var text B =Trim(Part($value,2,";"));
var text C = Trim(Part($value,3,";"));
etc
var text Z = Trim(Part($value,26,";"));
Case([value in another field]),
1, "$A,
2, $B,
3, $C,
etc
26, $Z)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------
------------------------------
Jonathan Heuer
------------------------------
- MarkShnier__YouWell 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
------------------------------