topic Try [Column Name] LIKE '*SAM' in Product Forum

Filter collection - Contains / wildcard

samuel_a_thomas — Thu, 27 Oct 2016 19:04:00 GMT

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

Try [Column Name] LIKE '*SAM'

John__Carter — Thu, 27 Oct 2016 19:27:00 GMT

Try [Column Name] LIKE '*SAM'

What about filtering using

shahariar_k_bhu — Fri, 04 Nov 2016 15:33:00 GMT

What about filtering using InStr function? InStr([Column Name]; ""SAM"") > 0

Just want to confirm that

WimLogister — Thu, 24 Aug 2017 19:11:00 GMT

Just want to confirm that John's ""LIKE"" pattern works great.

Just to elaborate, the filter

SébastienBulté — Mon, 28 Aug 2017 16:54:00 GMT

Just to elaborate, the filter action uses SQL syntax (like this: https://www.w3schools.com/sql/sql_like.asp )