picking certain rows based on certain word

Question

can someone help me how to pick certain rows based on certain words.

Input Data

TypeItemExpIncomeYELLOWA50100GREENB60220REDC40540BLACKD20620WHITEE56260ORANGEF65584YELLOWG70600BLUEY80400

Output Data-

TypeItemExpIncomeGREENB60220REDC40540BLACKD20620WHITEE56260ORANGEF65584

jrlindem · Accepted Answer

There's a number of ways you can do this.

One is using a Filter Tool.  If you know the values you don't want, you can specify those in your Filter logic and then just move downstream with the values that you do want (true vs false path):

The Filter function I used is:  [Type] != "YELLOW" AND [Type] != "BLUE"

If your list is longer, and it doesn't make sense to build a big long filter function, then you can list the values in a separate Text Input Tool and have that act as a crosswalk.  Then you JOIN this to your original data and just keep the LEFT stream: