Forum Discussion

Re: I want to extract a specific piece of text from another multi line text field.

What if the data is in the multi-line text with only a comma and no space?

------------------------------
Jessica Adkins
------------------------------

2 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    You would have to post a representative set of data and what you are trying to parse out.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • AdamKrzyzanek's avatar
      AdamKrzyzanek
      Qrew Captain
      I know it is quite old post (I found also 2 from 2017 and 2015) but I believe I found quite Elegant way to overcome QuickBase "limitation" in terms of finding text string vs "text value containing all the possible delimiter characters"

      What I did was using SearchAndReplace formula to Look for specific text and replace it with special character which I do not expect normaly in text  (% or #)​
      In this case:
      Name:    Juliet Smith
      Email:   xyzzy@yahoo.com
      Phone:    3224405555

      Length(Left(SearchAndReplace([TextAbove],"Email: ",#"),"#"))

      Than it gives where # mark is available and using MID and other SearchAndReplace formula you can find where MID should Start and End.

      I had Quite Long thinking but works.



      ------------------------------
      Adam Krzyzanek
      ------------------------------