Find the powerpoint file attached to clear instructions.
The main points include:
I just need the code to run the PosTitles and look it up on the unnecessary keywords list to clean it up
column E (for collar) - should reflect entries such as "white", "blue" or g"grey" , not the actual position as you showed in column A
Column A and Column G - should be cleaned as specified in slide 2 of the powerpoint I sent
database 1: external data entries that are NOT found in internal data
database 2: external data entries that are found in internal data
FIELDS in output database 1 and 2 should be the same as the source database.
CONTENT of output database 1 and 2 should have clean position title and company name
Additional field in database 1 and 2 is the collar, should reflect "blue", "white", or "grey" per line entry.