View Single Post
 
Old 06-20-2017, 09:04 AM
slaycock slaycock is offline Windows 7 64bit Office 2013
Expert
 
Join Date: Sep 2013
Posts: 255
slaycock is on a distinguished road
Default

If I run the updated code on

OrganizationDate
2 Data row
3 Data row
4 Data row
Undefined category
6 Data row
7 Data row
8 Data row
Life Sciences
10 Data row
11 Data row
12 Data row
Undefined category
6 Data row
7 Data row
8 Data row


I am left with

OrganizationDate
2 Data row
3 Data row
4 Data row
Life Sciences
10 Data row
11 Data row
12 Data row

So for point 1 check the spelling of the Life Sciences category in your document matches that in the KeyTerms string (and that includes the number of spaces between the two words)

For 2 I can't reproduce what I think you are saying in that you are getting

OrganizationDate
2 Data row
3 Data row
4 Data row
Undefined category
Life Sciences
10 Data row
11 Data row
12 Data row
Undefined category


Which I don't.
Reply With Quote