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

Outcomes