Search by keywords. If any word from First field matches with any word from Second field

[#1]

I want to compare first list box L1 to second listbox L2 by keywords.

First Listbox:

Code,     Description1

101,     LightPath Client

102,     PNI-WNI_M

103,     Telecommunications Capacity Management

104,     Allen Key set 9pcs metrics

105,     Fixed Delivery Charge

Second Listbox:

Description2

Telecommunication charges

Chemical including Bio Chemicals

Minerals

Paper Client

I want the code in third listbox from above two.

That should be

Code,     Description

101,     Paper Client

103,     Telecommunication charges

Search by keywords. If any word from Description2 field matches with any word from Description1 field, then it will be appear with code.

Please reply if anyone did something like this.

Thanks

[juleshartley]

Phew, that is not straightforward! I think you would have to build something in the script...

I would split each description and description 2 onto a new line for each separate word and then use applymap to associate a code with a Descrption 2.

[juleshartley]

ps. You can use 'subfield' to split a string out into separate lines...

eg.

Mapping Load subfield([Description],' ') as Description_Word, Code

from ...