Search the Community
Showing results for tags 'delimited'.
Hello, I'm trying to figure out how to filer records with a text field that contains comma delimited values. The problem is the search doesn't actually recognize 'delimited' in a field and so 'contains' will bring up records that I need to filter out. For example, if a record's text field has a value of 1,2,3,4,12,22 the user might do a search/filter; "‘contains 2” (it can’t do = 2 because the actual value of the field is “1,2,3,4,12,22” and “2” won’t be equal to it). But the ‘contains’ function will bring up records with not only ‘2’ in them but also ’12’ and ’22’ etc. I tried using "" in the search box so "2" would bring up records with just 2 and not 12 or 22, etc, but this doesn't work either. Does anyone know how to deal with this? I can't use List for data type as these records are imported and you can't import to List fields. The value 1,2,3,4,12,22 denotes a multi-record, meaning that record is related to 6 different records in another table. Thanks for any help!