Exclude specific item(s) from existing column into a new column

[PamG]

Hello,

I have a simple query but cannot do successfully after trying a few methods.

I have an existing column of data which is all good, however, I now need to create a new column with a couple of the existing items removed from it.

For example:

My ExistingColumn has all these items but now need a NewColumn to exclude eg the work Mango from it. 

Hope its an easy

Many thanks in advance.

Regards

[FrederikE]

Hey @PamG,

You can just duplicate the column via a formula and then use Find&Replace with an Input/Text Input of a list of items that should be removed. 

Make sure all fields are string for F&R.

[RobertOdera · Accepted solution]

Hi @PamG 

try the below in a formula tool for NewColumn, where

IF !CONTAINS([ExistingColumn],"Mango")
THEN [ExistingColumn]
ELSE Null()
ENDIF.

Cheers!

[PamG]

Hiya @RobertOdera

This is brilliant. Thanks so much for this, it worked brilliantly and a tad simpler too!

Thanks also @FrederikE

[RobertOdera]

You're most welcome @PamG!