custom delimiter
Comments
-
You can accomplish this in a beast mode:
STR_TO_DATE(dateField
, '%Y%m%d')
Result:If I solved your problem, please select "yes" above
0 -
Hi @Tcole ,
Here you go:
If doing this in beast mode/ SQL:
CONCAT(LEFT(`whatever the date column is named`,4),'-',SUBSTRING('whatever the date column is named',5,2),'-',RIGHT('whatever the column is named',2))
This will just give you a string though. If you need it to be a real date then in the ETL you can do the same formula, but like this:
CAST(CONCAT(LEFT(`whatever the date column is named`,4),'-',SUBSTRING('whatever the date column is named',5,2),'-',RIGHT('whatever the column is named',2)) as date)
OR
DATE(LEFT(`whatever the date column is named`,4), SUBSTRING('whatever the date column is named',5,2), RIGHT('whatever the column is named',2))
How this works is I'm ripping apart the values and putting them back together. So I'm saying "Start from the left and go 4 places…Then start in the middle at place 5 and go two spots.
Hope that helps. I explain that a bit more in this video: https://youtu.be/tqa-ZqewVt0
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 304 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 105 SQL DataFlows
- 644 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 772 Beast Mode
- 74 App Studio
- 43 Variables
- 726 Automate
- 185 Apps
- 466 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 135 Manage
- 132 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive