Filter collection - Contains / wildcard
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
27-10-16 08:04 PM
Dear All,
I am looking for a way to filter my collection based on several filter + contains functionality .
I know that, As input in the action stage we write the filter as following :
"[ColumnName]='"&[data we want]&"'"
But Know i would like to filter on a field containing the word "SAM" for example so I try these expression:
"[ColumnName]='"& "*SAM" &"'"
and as well "[ColumnName]='"& "%SAM" &"'"
But nothing is working ? could you please help me ?
Thanks a lot if someone has already succeed with this, I will be a huge help for me !!!
Best regards
4 REPLIES 4
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
27-10-16 08:27 PM
Try [Column Name] LIKE '*SAM'
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-11-16 03:33 PM
What about filtering using InStr function?
InStr([Column Name]; ""SAM"") > 0
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
24-08-17 08:11 PM
Just want to confirm that John's ""LIKE"" pattern works great.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-08-17 05:54 PM
Just to elaborate, the filter action uses SQL syntax (like this: https://www.w3schools.com/sql/sql_like.asp )
