Storing text in an array
I have a simple macro that maps one list of company names against another,
such that small differences are ignored.
For example, American Packaging Corp would return a match (using this macro)
with American Packaging Inc
I want to improve its accuracy, and to do this I want to store 200 "common"
words in an array, then test to see if a word is contained in this array.
For example:
myCommon = {"American", "Company", "Corporation", "Ltd", "Inc"...)
blnCommon = True if a word exists in the array, and blnCommon = False if it
isn't in the array. This is the line of code that isn't working for me.
If I can get help with just this line of code, then I can muddle on from
there.
Thanks
Daniel
|