Forum Discussion

PatrickPatrick1's avatar
PatrickPatrick1
Qrew Trainee
9 years ago

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

Say the multi-line text field is called [Data] and it contains the following lines of text: Name: QuickBase Move Date: 9/15/2016 Phone: 000-000-0000 The info before the colons will always be t...
Tables and fields
JessicaAdkins's avatar
JessicaAdkins
Qrew Cadet
6 years ago
What if the data is in the multi-line text with only a comma and no space?

------------------------------
Jessica Adkins
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
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
    6 years ago
    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
    ------------------------------