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!
InStr and CHARINDEX are common SQL functions that can get the job done.
you can use Regex expressions in Magic (Replace Text)Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
There's a few ways to do this depending on how you want to process your data.
Using Magic ETL Replace Text tile:
This is assuming the date is ALWAYS in the YYYY-MM-DD format following "EXPIRED "
Here's a copyable version of the regular expression:
Using a Beast Mode:
SUBSTRING(SUBSTRING(`text_col`, INSTR(`text_col`,' EXPIRES ') + LENGTH(' EXPIRES ')), 1, 10)**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Awesome, it sounds like that will work for me! Thanks0
- 7.7K All Categories
- 2 Connect
- 918 Connectors
- 244 Workbench
- 476 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 35 Visualize
- 198 Beast Mode
- 2K Charting
- 8 Variables
- 16 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 23 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部