Field with comma separated text
I'm new to FMP so go easy on me here. I've imported an excel file where the "years" field contains multiple years separated by commas so one record in the years field might read like this "2001, 2002, 2003". Some records have one year and some have as many as 10 or more. I'm using a portal and trying to filter it based on year search but FMP won't return any fields that have the multiple years in it. Only if it has the one year I'm looking for by itself. How can I set this up to filter it the way I want?