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