Good day everyone,
Coming to the experts for assistance. I must say that I am not an Excel expert and my programming skills are limited so I would appreciate working code over pseudo code. Thank you in advance.
I am looking for a parser that would find specific words in an Excel worksheet cell using a list of words or dictionary for the most common spellings/mispellings of the word. Once the word(s) is found, a copy of the word will be placed under different Excel columns. Each column is a different category.
The code would read a text file (dictionary file) and compare the word(s) against Column C (Event Description). When the word or words are found, the word or words are copied to Columns D, E, F, G or H after logic in the code determines the category the word falls under; or simply by specifically comparing the words under different headings in the text file (FRUITS, VEGETABLES, PRODUCE, CARB SIMPLE, CARB COMPLEX.
One column, like Column E (Vegetables) could have all the vegetables found in Column C (Event Description) separated by commas. A different way would be to have each vegetable word found copied to a separate column; for example, corn would be placed under the column Vegetable 1, carrots would be placed under the column Vegetable 2 and peas would be placed under the column Vegetable 3.
For example:
Column A (Name): Mary
Column B (Last name): Jones
Column C (Event Description): This morning for breakfast I had oatmeal with milk, sugar and bananas. For lunch, I ate a bowl of vegetables which included corn, carrots and peas.
Column D (Fruits): bananas
Column E (Vegetables): corn, carrots, peas
Column F (Produce): milk
Column G (Carb simple): sugar
Column H (Carb complex): oatmeal
Thank you,
Edwin
Bookmarks