AnsweredAssumed Answered

Search string for specific value

Question asked by barand on Jan 19, 2017
Latest reply on Jan 19, 2017 by taylorsharpe

Dear Filemaker users,


I have a table with lists in the field name LIST. I want to be able to do a search through these lists and show only the row that has a match with a certain value in the field name list.


F.e. the following lists occur in the field name LIST:

list 1: 1 11 13 78 9

list 2: 32 91 2 1 14

list 3: 2 31 11 92 101


I want only the records to be shown that have the value "1" in the field name LIST. Which would result in showing only the records that include list 1  & 2. In Excel I would use the MATCH function and then use a filter to show only the rows that show where the value "1" has been found.


I hope you guys/girls can help me.


Btw: I own a Filemaker Pro product, so custom functions are unfortunately a no-go.


Kind regards