Keyword Search

[Anonymous]

Hi,

I have a word list which I need to search in the item description field. E.g. words like Gold, Silver, Copper, etc. I tried using the wildmatch function in the script "where WildMatch ([Item Description], '*Gold*', '*Silver*, '*Copper*' and it worked fine.

The problem I am facing is that I need to show a column alongside the item description stating which word was found in which field, e.g.the final output should look something like below along with other fields in the file

Keywords     Item Description

Gold             Bought Gold worht USD2000

Silver           Silver Ornamanet purchase

Copper         Copper plates bought worth 1000 USD

Please advise

Thanks

Sunny

[marcus_sommer]

You could use pick(match()) for this:

pick(WildMatch ([Item Description], '*Gold*', '*Silver*, '*Copper*'), 'Gold', 'Silver', 'Copper')

But you will get only the value of the first matching.

- Marcus

[swuehl]

You can also have a look at

Keyword Mapping with Description