Beast Mode

Beast Mode

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!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answer

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

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

    If I solved your problem, please select "yes" above

Answers

  • Member
  • Member

    all set. no need for assistance

  • Member

    ticket can be closed

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

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

    If I solved your problem, please select "yes" above

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In