Forum Discussion

GeneStrelkov's avatar
GeneStrelkov
Qrew Cadet
4 years ago
Solved

Extract Text Between 2 special characters

I've been going through several posts here all morning, trying to find how I would extract text that's between 2 characters, and I can't seem to figure out.  I have the following field text: <?xml...
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    4 years ago
    Try this

    Left(Right(NotRight([My Field],1),">"),"<")

    It should work as long as your field always ends with    >99999</string>



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
np

var text RawResult = Left(Right(NotRight([My Field],1),">"),"<");

IF($RawResult <> "ERROR",  $RawResult)

// the formula above uses a formula variable called RawResult to hold an intermediate calculation. A formula variable is like a field but it only has life within the formula box itself.
https://help.quickbase.com/user-assistance/formula_variables.html


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
GeneStrelkov's avatar
GeneStrelkov
Qrew Cadet
4 years ago
Thank you, Mark!

------------------------------
Gene Gene
------------------------------