Help identifying and isolating a date held within a string of text
I'm hoping some creative minds out there can help with a business problem I am having.
I am looking to create a Beast Mode field for expiry date, however the source of the expiry date is held within a string of text.
Example: "Building agreement in place with John Smith - signed via docusign , EXPIRES 2020-04-28 / John Smith aware of upcoming events"
The format is always the same at the expiry aprt (comma, space, "expires", space, DATE, space, /) so I can do it easily in Excel using Find and Replace.
Does Domo have anything similar I can use to locate and isolate this date?
Thanks in advance!