4 Replies Latest reply on Jan 19, 2017 2:25 PM by taylorsharpe

    Search string for specific value


      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