FAQ: How to do "like" string comparison?

Another FAQ we receive:
Is there a way to filter similar to SQL’s “LIKE”?

Yes, there are two ways:
First, by using the Like function, to make a boolean column, then filtering that column for it’s true values.
This will allow you to use specific regex to get the exact pattern you are looking for:
Like( [Email], "%gmail%" )

The other way to filter a column is to use the built-in Like option for a column filter like so:

1 Like