Searching using comma separated list

Hi there

I am trying to achieve a search like this.

My data has a field which contains a comma separated list of keywords. The visitor can enter a list of comma separated keywords. I want to return results where the data contains any of the words entered in the search.

I can see it's straight forward for the results to contain any keywords but not if a field contains a separated list.

My thinking is I explode the field into an array but I'm not sure how Data Bridge Search can handle that.

Your advice would be very much appreciated.

Many thanks

Jon

In Data Assist Search, use a Keyword search type, and set the OR Separator to be a comma.

Thanks Jason.

I've done that and it's not working but I think it's because my data has a comma separated list and so does the search string.

To clarify, my data has something like this in a single field:

UK, USA, FR, ES, IT

The search string may have something like this:

UK, FR, DE

The record needs to be selected because there is at least one match (UK and FR will match in this case).

How can I do this?

Cheers

Jon

Using the Key Word search type, and setting the OR comparison to a coma with a space:
", "

should work, just make sure to select the includes comparison type.

send a copy of the page if continue to have troubles.

Thanks Jason.

I'm afraid it's still not working.

I have a record containing a field with this data:

"wales, ld"

and a search box containing:

"ld, np"

so I should be getting the record because of the match for "ld".

I've removed all the other elements in the search so I just have this one, have done it as you suggest but it's returning no results.

Any ideas?

Cheers again

Jon

send a copy of the page if continue to have troubles.

Thanks Jason. Where should I send it to?

Hi Jason

I'm an idiot! I had the wrong variable in there. I been looking at it for so long, I just didn't see that. It seems to be working a treat now.

Thanks again for your help.

Jon

Ok, glad to hear it is working.