Excel function/macro -- extract proper nouns
Experts:
Need some help with developing -- if all possible -- a function/macro -- that scans through a single columns (in a spreadsheet) and "detects" all proper nouns.
Then, in step #2, it would add only the nouns into another column (separated by commas).
For example, I may have the following two (2) sentences in column A:
The agency made the announcement late Tuesday night, hours after a union representative told CNN that the train engineer apparently "was nodding off and caught himself too late" before the accident.
On Monday, one of the nation's most esteemed weeklies, New York magazine, announced that it would soon shift to an every-other-week publishing schedule while beefing up its Web production.
Then, once the function/macro has been applied, I'd like to see the following nouns in column B:
B1: agency, announcement, union, representative, train, engineer, accident
B2: nation, magazine, schedule, production
Note: In actuality, I have thousands of strings in column A. Some of them are short... some of them are longer.
Even if I only get the 80% solution, I certainly would be a huge time saver.
Any thoughts on how to accomplish this task?
Thanks,
EEH
Need some help with developing -- if all possible -- a function/macro -- that scans through a single columns (in a spreadsheet) and "detects" all proper nouns.
Then, in step #2, it would add only the nouns into another column (separated by commas).
For example, I may have the following two (2) sentences in column A:
The agency made the announcement late Tuesday night, hours after a union representative told CNN that the train engineer apparently "was nodding off and caught himself too late" before the accident.
On Monday, one of the nation's most esteemed weeklies, New York magazine, announced that it would soon shift to an every-other-week publishing schedule while beefing up its Web production.
Then, once the function/macro has been applied, I'd like to see the following nouns in column B:
B1: agency, announcement, union, representative, train, engineer, accident
B2: nation, magazine, schedule, production
Note: In actuality, I have thousands of strings in column A. Some of them are short... some of them are longer.
Even if I only get the 80% solution, I certainly would be a huge time saver.
Any thoughts on how to accomplish this task?
Thanks,
EEH
andrew_man
Can post your worksheet here?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So, we need a table of noun.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Dear Reg,
I agreed. Do you think we can use the WebService() function in the Excel 2013. But, we must find out the webservice provider.
Andrew
I agreed. Do you think we can use the WebService() function in the Excel 2013. But, we must find out the webservice provider.
Andrew
ASKER
All:
Thank you for the comments... I appreciate it.
Unfortunately, I won't be able to post the the worksheet. The "strings" are based on comments collected during a company survey. As you can imagine, some of the comments are "sensitive"... posting them online would surely expedite my getting laid off. ;)
Also, I don't have a ready table of nouns so that it compare it against. I completely understand this is tricky w/o having a data dictionary to compare it against.
Based on a quick look of the comments, anything in the English language would qualify. On the other hand, if a general e-dictionary with, e.g., 50,000 nouns would be somewhere posted online, I think it'll catch maybe 75% or more of the content.
EEH
Thank you for the comments... I appreciate it.
Unfortunately, I won't be able to post the the worksheet. The "strings" are based on comments collected during a company survey. As you can imagine, some of the comments are "sensitive"... posting them online would surely expedite my getting laid off. ;)
Also, I don't have a ready table of nouns so that it compare it against. I completely understand this is tricky w/o having a data dictionary to compare it against.
Based on a quick look of the comments, anything in the English language would qualify. On the other hand, if a general e-dictionary with, e.g., 50,000 nouns would be somewhere posted online, I think it'll catch maybe 75% or more of the content.
EEH
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
aikimark -- thx, I'll look into that one.
JimFive -- excellent point. Frequency count may facilitate findings the important "nuggets". Any recommendations how to accomplish that in Excel or Access?
EEH
JimFive -- excellent point. Frequency count may facilitate findings the important "nuggets". Any recommendations how to accomplish that in Excel or Access?
EEH
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.