Separate Date from the text
Hi,
I want to separate the Date from the text and put it in a new filed called "launch Date"
For eg: Suppose the text is "Email 2021-03-01 best practices in Email Marketing"
I want to separate out the "2021-03-01" text and put it in new filed called "launch Date". then I will update that filed datatype as a "Date"
Please suggest the code.
Answers
-
If you know that your text is always going to start with "Email somedate" then you can use the substring function to extract the date. In this example, you would do SUBSTRING(
textfield
,7,10) to get the date. You could also wrap the STR_TO_DATE function around the substring function to format it in a particular way if you would like.If the location of the date is going to vary in the text field, this will be much more difficult.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
use regex to identify if a set of characters are formatted as a date.
then use INSTR or SUBSTRING to try to extract the set of characters
then use STR_TO_DATE to convert the extracted values to date.
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"2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive