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
Jonathan,
I probably misunderstood the question. The formula field would return the actual value if the value is found in the string. The example returns "V23-4072", did you need the index of the value?
------------------------------
Neil Schneider
------------------------------
I probably misunderstood the question. The formula field would return the actual value if the value is found in the string. The example returns "V23-4072", did you need the index of the value?
------------------------------
Neil Schneider
------------------------------
Neil I'm sure I didn't clearly explain. Once I search for "V23" and obtain it's position, I'll ultimately want to get the value after the hyphen, "4072". But if I can find "V23" in the larger string, I'm fairly confident that I can extract the part after the hyphen.
------------------------------
Jonathan Heuer
------------------------------
------------------------------
Jonathan Heuer
------------------------------
- MarkShnier__You
Qrew Legend
..Jonathan, was there a problem with using my solution an an approach?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- I haven't implemented it yet, but I think it would work fine. I was just hoping to find a solution which didn't limit the size of the array. Right now there are <10, but it could grow by quite a bit.
------------------------------
Jonathan Heuer
------------------------------- MarkShnier__YouRight, I think that you will find that using the formula language in the formula field boxes, you will not be able to generate an array.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
