Forum Discussion

MarkoKrajinovic's avatar
MarkoKrajinovic
Qrew Trainee
6 years ago

Formula to extract a part of text from one field to another.

Hi all, I want to extract a piece of information from one Rich Text field into a simple Text field, or multiple fields by using a formula. So, as an example, from [Intro] "Hi, my name is Marko, ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
I think that you would have to provide several examples of what the actual text is in order to know whether there's enough of a pattern in the data for a formula to be able to extract certain fields.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
  • MarkoKrajinovic's avatar
    MarkoKrajinovic
    Qrew Trainee
    6 years ago

    Hey Mark,

    Thanks for coming back to me! Here's an example of what I need as close to the real thing as possible:

    Field [Tag] contains: <script src="https://domain.com/article/script.sr?param1=test&param2=28&param3=8736452323&param4=0&param5=true&param6=1"></script>

    Field [Tag Extract] should contain: 8736452323

    I was able to extract param3=8736452323, by adding the ampersand as the delimiter, but I'm not able to narrow it down to just the number, which is between the = and the & characters.

    Hopefully, this can help with troubleshooting.

    Thanks!
    Marko



    ------------------------------
    Marko Krajinovic
    Sizmek
    Belgrade
    ------------------------------