Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
ps. You can use 'subfield' to split a string out into separate lines...
eg.
Mapping Load subfield([Description],' ') as Description_Word, Code
from ...