Find specific text within cell value and group via SWITCH formula

[Anonymous]

I have a column of string data that has various lengths ([Company Name]. Within this column I'd like to search for a word e.g. Meat. and group these into a category "Meat/poultry/fish".

Company Name	location, other grouping
Meats by Company A	Meat/poultry/fish
Meats by Company B	Meat/poultry/fish
Company C Meat Incorporated	null

I've tried SWITCH, FIND, CONTAINS STRING columns but it keeps find those that have the word Meats at the begining of the text string rather than in the middle or end.

Columns tried :

location, other Grouping1 = 
IF(CONTAINSSTRING('Events'[location, other],"*Meat"),"Meat/poultry/fish",'Events'[location, other])

location, other Grouping = SWITCH(
TRUE(),
FIND("Meat",'Events'[location, other],1,0)=1,"Meat/poultry/fish",
FIND("*Meats*",'Events'[location, other],1,0)=1,"Meat/poultry/fish",
SEARCH("*meats*",'Events'[location, other],,0)=1,"Meat/poultry/fish")

Is this possible?

[mahoneypat · Accepted solution]

Here is one way to do it.  You were setting your SEARCH =1 which is why it only looked at the beginning.

Has Meat = IF(SEARCH("meat", Events[Company Name],,0)>0, "Meat/Poultry/Fish")

Regards,

Pat