Regex Replace Issue
Hello,
I'm trying to do a regex replace to grab a combination of letters and digits but throw out the rows where I don't get anything.
Here is my formula:
case when REGEXP_LIKE(`Asset name`,'^.*([a-z]{4,5}\d{6}).*$')=1 THEN
REGEXP_REPLACE(`Asset name`,'^.*stc=?([a-z]{4,5}\d{6}).*$','$1')
else NULL end
To explain, I'm trying to pick up 4 or 5 letters after stc=(= sign is optional hence the '?') followed then by 6 digits. It is working for a lot of my data, but then I'm getting lots of rows that are picking up a pattern and showcasing it below in STC when it really should be blank. Because as you can see it shows stc and then no letters and therefore should be NULL. I have tested this pattern and this example on multiple regex helper sites and they all show that there should be no match. I don't know why domo might be picking this up.
Answers
-
I found the issue. It was the top equation that didn't have the stc=? part in it.
1
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive