Need to merge 25 Word Docs into one

curiouswebster
curiouswebster used Ask the Experts™
on
I have 25 Word Docs which represent 25 snapshots of this paper I have been writing, where I created a new copy before I made a change in direction and deleted some text. So I made a new filename so I would not over-write any copy, but now I need to "mine" all that old text which had ben abandoned.

I want to make a "mashup" version of the file so I can proof it for ideas on topics that I abandoned months ago.

How do I do this?

I tried the merge feature of Word, but found it did not merge the docs as expected. I want to use some merge feature so that I do not make the doc longer than needed by releasing the same paragraphs and pages. Instead, I understand there will be no meaning to this text, expect it will remind me of the topics I abandoned.

I also tried exporting them as text, then using Beyond Compare to merge them, but once again, it did not combine the files.

Is there a way to extract all words in a file as a CSV file? If I could get that for each file sandpit them into one huge Excel Column, I could scan that column and at least find key words, while key concepts would be impossible to uncover...

Any ideas?

Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Shaun VermaakSenior Consultant
Awarded 2017
Distinguished Expert 2018
Commented:
The best would have been to enable "Track Changes" at the start
This would have produced the output you wanted

As for doing this without it, it probably will be manual
curiouswebsterSoftware Engineer

Author

Commented:
I need an automated way to strip out duplication and keep all text which occurs in the docs 1 or more times. Is this possible?
curiouswebsterSoftware Engineer

Author

Commented:
What about the idea of converting each file into one CSV file I can then import into Excel? Is there was way to make this kind of export?
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

Retired
Top Expert 2012
Commented:
In the following, a unit could be a section, a sentence or a paragraph.

It would be possible to write a VBA macro that would import all such units to a new document, omitting any that are identical to any that are already in the new document. They could be preceded by some 'tag' information, such as the source document(s) name and the unit's index in that document
curiouswebsterSoftware Engineer

Author

Commented:
Thanks for the help. I will probably revert to speed reading and get over this hump.

Thanks
Joe WinogradDeveloper
Fellow 2017
Most Valuable Expert 2018

Commented:
Is there a way to extract all words in a file as a CSV file?
I wrote a program called WordCounts that is discussed at this EE thread:
https://www.experts-exchange.com//questions/28970468/Software-to-count-how-many-instances-of-words.html

It creates a CSV file with two columns — column A contains each word in the Word doc and column B contains the count, i.e., the number of times that it appears in the doc. I could enhance it to put the file name in column C, then you could run it on all 25 Word docs and, as you phrase it, "sandpit them into one huge Excel Column". You could sort the one huge column (A) and then you'll be able to see which words appear in which files by looking at column C. Let me know if this interests you.

Btw, I recollect from other threads with you that you're a Mac user. Are these Word files on a Mac? If so, can you move them to a Windows system with Word? The reason I ask is that my WordCounts program runs only on Windows (32-bit and 64-bit XP, Vista, W7, W8/8.1, W10) with Word 2007, 2010, 2013, 2016. Regards, Joe

Update: Oops...when I hit the Submit button, I see that you already closed the question. Even so, let me know if WordCounts interests you.
curiouswebsterSoftware Engineer

Author

Commented:
Joe, thanks a bunch. I think I will revert to speed reading...
Joe WinogradDeveloper
Fellow 2017
Most Valuable Expert 2018

Commented:
> speed reading

hehe...good one...and probably a good idea.
curiouswebsterSoftware Engineer

Author

Commented:
Joe,

If you wanted to give me the script, that would be great.

I created a question for you in that case...

https://www.experts-exchange.com/questions/29005221/Need-to-get-a-Word-Count-from-a-Word-file.html

I do not need the filename, if that's extra work. I can use the Mac Finder's Word Search to dig up the file if it's a word I need to tack down to a text snippet. Unless it's easy to add.

Thanks.
Joe WinogradDeveloper
Fellow 2017
Most Valuable Expert 2018

Commented:
> I do not need the filename, if that's extra work.

Was just a few lines of code — already did it. Fully qualified file name is in column C. I'll head over to your new question.

> I can use the Mac Finder's Word Search to dig up the file

Won't be needed, but your comment reminds me to emphasize that WordCounts will run only on Windows.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial