Filter multiple text from Text Input (Alteryx Server) which are seperated by ","

[Venky_1992]

Hi All,

Use Case: There is a name field,
Name
Jack Smith
Jack Paul
Angel
Prince
Samuel Winston
Fraud

I am trying to filter them from Text Box (Alteryx Server) where I want to give

Input in the Text Box

Jack, Prince

Note: I am not giving the full name here and names are seperated by comma

and output should 

Name

Jack Smith
Jack Paul 

Prince

[caltang]

Sorry, I do not understand your request - can you make it clearer please? 

[Venky_1992]

I think you are confused with the Text Input I have corrected that its Text Box

[caltang]

Basically you have a list of names, and you want it to filter for the list of names that matches your criteria?

In other words, you are looking to update a CONTAINS expression in a Filter Tool, that takes in "," as the delimiter. Have you tried this? I am on my phone on the way to someplace so I can't build something out. But the logic above - can you see if it matches your needs?

[Venky_1992]

yeah I want to update  CONTAINS so that it could filter for all text(from INput) seperated by delimiter 
Main thing is I want the expression which will be used in Action tool
I think in Action tool we have "Update value with formula" where we gice the expression to update values in CONTAIN that I want to know 

If you have other way around please tell me !

[caltang]

The expression should be:

REGEX_CountMatch([YourField],”ToReplace1|ToReplace2”)

The action tool should replace “ToReplace1|ToReplace2” - instead of comma use a | so that the Regex can filter for you. Try it!