How to remove words from a drop down choice in Beast mode

Hi Team,
I was hoping to have some assistance on this request on creating a beast mode.
There is a custom field that we have and want to remove characters from the drop down choices and then also remove all the other choices as well.
We have drop down choices: Access Carrier- Circuit Not working, Access- Carrier- Configuration, and Access Circuit Not Ready.
What we want is to remove the Access Carrier and to just have everything after the hyphen.
But we also have other choices for the dropdown but we do not want to have those included just anything that has Access Carrier at the beginning.
Any assistance is greatly appreciated. Thank you.
Welcome!
Best Answer
-
You can use 2 beastmodes:
1. This one will filter out anything that isn't Access Carrier.
CASE WHEN `field` LIKE 'Access Carrier -%' THEN 'In' ELSE 'Out' END2. This one will remove the text from the strings:
REPLACE(`field`,'Access Carrier - ','')If I solved your problem, please select "yes" above
0
Answers
-
0
-
all set. no need for assistance
0 -
ticket can be closed
0 -
You can use 2 beastmodes:
1. This one will filter out anything that isn't Access Carrier.
CASE WHEN `field` LIKE 'Access Carrier -%' THEN 'In' ELSE 'Out' END2. This one will remove the text from the strings:
REPLACE(`field`,'Access Carrier - ','')If I solved your problem, please select "yes" above
0
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 83 App Studio
- 46 Variables
- 777 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive