Data Bridge Search for keywords not quite working
Hi there
I have a field containing post code letters, comma separated. The search consists of lots of tick boxes, one per post code. I'm using the keywords feature and 'contains' and it works fine apart from one, quite serious, issue.
In the UK we have a post code of GL for Gloucester and another of G for Glasgow. If the result contains GL and the search is for G then it's showing the record.
As the data is comma separated I would have thought this would work but after lots of testing I've realised that it's this G being in both G and GL that's causing the problems.
Help needed!
I'm using the latest of every version btw. Latest Data Bridge, latest DW CS6, latest OSX (Mountain Lion).
Many thanks
Jon