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

Abe
Abe Member
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.

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    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

  • Abe
    Abe Member
    image.png
  • Abe
    Abe Member

    all set. no need for assistance

  • Abe
    Abe Member

    ticket can be closed

  • ColemenWilson
    ColemenWilson Coach
    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

Categories