String within a string

Hello, I’m attempting to find a string text (last name) within a longer string text (email)… I’ve tried using Match Text, but it only matches if starting with the first letter of the longer string text. I need to be able to find within any part of the longer string text (email)

Any ideas?

Hi, like this?

shakira.gh (8.2 KB)
shakira

2 Likes

Yes although I have a long list of last names, and longer list of emails…

I actually solved it by grafting the pattern input, but thank you!

…so that you don’t have to type the asterisks yourself:
shakira.gh (9.2 KB)

1 Like

You almost got all the Teenage Mutant Ninja Turtles :wink:

Good question though, why “shakira”?