m.TheWord3 appears by magic. It has to get a value from somewhere, but this code doesn't show that for the second SCAN. For that matter, m.TheWord1, m.TheWord2 don't get values from anywhere either.
>In the first scan, TheWord3 is set to Indicator. Where does Word3 come from in the second SCAN?
>
>TheWord(s) exist in a table. Word3 is TheWord3 throughout for comparison to TheWord1 and TheWord2 to check for, and avoid duplication. Once the comparison is done and TheWord3 is not the same as 1 or 2, it is saved and TheWord4 begins being compared to 1,2 and 3. Once(or if) 5 distinct indicators are found and saved the code moves on to the next process.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer