532570 Need a Microsoft Word macro to anonymize survey data
N/A
Completato
Pubblicato più di 12 anni fa
N/A
Pagato al completamento
I have a set of Word documents that I need to remove some data from. The Word documents are the questions and answers to a survey that people had to fill out. The job of the macro is to take out the names and other information which would identify who filled in the survey.
Here are examples of what it must do ...
1. One question in the survey is "What is your first name?". Next to it is what the person wrote e.g. "Catherine". The macro must find the word "Catherine" and then replace the word "Catherine" everywhere in the document by the text [FIRST NAME].
2. Another question is formatted as a table with 1 row and 3 columns. The first column has the word "Nominator". The other two columns have some more text as well as the answers. All the text in the other two columns of this table must simply be deleted.
3. I want to find all the words that might be people's names in the document. So the macro must output all the words that the person wrote in the survey which start with a capital letter (but are not from a list of common words like London"). I can then choose which of these words I want the macro to find and what I want to replace them by. So for example, there might be the text "Script Lance" and I want to replace it with the text "[BUSINESS NAME]". This doesn't need to be a sophisticated interface.
I attached an example of a table in the survey. Any questions - feel free to ask me in the project message board.