Forum Discussion

GeneStrelkov's avatar
GeneStrelkov
Qrew Cadet
4 years ago

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...
  • MarkShnier__You's avatar
    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
    ------------------------------