Replace part of string with another value in Domo Cards
I have a data set showing some page names and paths of my website, a part of which has to replace with another in the domo card.
Can it be done using beast mode, using any functionality similar to 'Replace' in mysql.
Original Value: 'Site1::LandingPage > Site1::My Cart > Site2:Checkout Initiate:Checkout'
Required value: 'Landing Page > My Cart > Checkout'
Thus, 'Site1::LandingPage has to be replaced with 'Landing Page' , 'Site1::My Cart' is to be replaced with 'My Cart' and so on.
Any insights would be helpful.
Yes you can write a beastmode using Replace() , hopefully your values to remove are consistent.
you will need to replace within replace meaning one value at a time to replace all occurrences
for example start replacing the 1s , then a replace of 2s within the prior replace
here it is the code for your example , notice the last line is the actual beastmode to use
-- REPLACE(`String to replace`, 1, '') Replacing the number 1
-- REPLACE(REPLACE(`String to replace`, 1, ''), 2, '') Replacing the number 2
-- REPLACE(REPLACE(REPLACE(`String to replace`, 1, ''), 2, ''), 'Site', '') Replacing the 'Site' values
-- REPLACE(REPLACE(REPLACE(REPLACE(`String to replace`, 1, ''), 2, ''), 'Site', ''), ':', '') Replacing the ':' Values
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(`String to replace`, 1, ''), 2, ''), 'Site', ''), ':', ''), 'Checkout Initiate', '')Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0
@Godiepi provided you with the beastmode and will work if all of the replacement values are consistent and limited. If the Sites are dynamically named or many then I would recommend a mysql dataflow with the sql below. I put your string in a table named data and named the column col_1 to keep the example shorter.
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 77 Cards, Dashboards, Stories
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive