Forum Discussion

GeneStrelkov's avatar
Qrew Cadet
3 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
    3 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