Forum Discussion

NeilSchneider's avatar
NeilSchneider
Qrew Cadet
5 years ago

Re: Find position of text string in larger string

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

4 Replies

  • JonathanHeuer's avatar
    JonathanHeuer
    Qrew Cadet
    5 years ago
    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
    ------------------------------
      • JonathanHeuer's avatar
        JonathanHeuer
        Qrew Cadet
        5 years ago
        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
        ------------------------------