Regex_replace doens´t work in MySQL
Hi there,
I would like to adjust a column by using Regex:
SELECT *,regexp_replace(
regexp_replace(
`Page`,
'https://www.[^\/]*\/.{2}\/[^\/]*\/', ''),
'\\?.*',
''
) AS Townslug
FROM `ga_pageviews_per_town`
Background info:
DOMO loads our Google Analytics urls. Afterwards I need to replace all valid urls into a specific string, so I can join IDs from another table.
Unfortunately, I receive an error. Is there a way to use regex replace in MySQL?
Many thanks
Best Answer
-
You can use regex expressions in the ETL replace text tile.
I don't think there is an option to use regex in MySQL
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Answers
-
You can use regex expressions in the ETL replace text tile.
I don't think there is an option to use regex in MySQL
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
Thanks for your suggestion.
I checked it out, I thought it would work for my purpose, but I was wrong.
0 -
Domo seems to be running MySQL 5.6 which doesn't have those regex functions. I don't know if they plan to upgrade to MySQL 8.0 which does have native regex support but it may be something you want to talk to your rep about, or at the very least, keep your eye on any patch notes/news releases.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive