Forum Discussion

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

Qrew Cadet

9 years ago

Very clever, Dan! Thanks for the ideas and inspiration.

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