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

AbeB

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.

ColemenWilson

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' END

2. This one will remove the text from the strings:
REPLACE(`field`,'Access Carrier - ','')

AbeB

AbeB

all set. no need for assistance

AbeB

ticket can be closed

ColemenWilson

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' END

2. This one will remove the text from the strings:
REPLACE(`field`,'Access Carrier - ','')