I think it might be useful to have an option in the merge/join block to only merge the first match.

Here is what I'm trying to do. I have a field containing a string of text which sometimes contains place names. I wish to match up the place names in this text string with the list of place names in the lookup data built in the data sources. Because it's a string of text I'm using the "contains" criteria in the merge/join block but this means that manchester and chesterfield will match chester. There are many other instances of this happening, too many to sort out manually.

If I sorted the data so that place names which contained other place names were at the top, and then I could merge the first match then I think this would solve this problem. Is this a possibility for future releases?

In the mean time can anyone think of a way round this?

Thanks, Martin