Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-28-2018, 01:58 PM
bianson bianson is offline Identify duplicate phrases within a document Windows 7 64bit Identify duplicate phrases within a document Office 2007
Novice
Identify duplicate phrases within a document
 
Join Date: Jan 2011
Posts: 8
bianson is on a distinguished road
Default Identify duplicate phrases within a document


I have a multi page Word document where I have typed in quotations I have collected over the years. The problem is that I have hundreds and hundreds of these quotations and now realize that some have been duplicated over the years. Is there a process or a software package that would scan my document and identify the duplicates which I could then safely remove?
Reply With Quote
  #2  
Old 05-28-2018, 04:13 PM
macropod's Avatar
macropod macropod is offline Identify duplicate phrases within a document Windows 7 64bit Identify duplicate phrases within a document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,342
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

What kind of formatting is applied to the quotations? Do they cite authors and, if so, how are the author names separated from the quotations to which they refer?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-28-2018, 06:54 PM
bianson bianson is offline Identify duplicate phrases within a document Windows 7 64bit Identify duplicate phrases within a document Office 2016
Novice
Identify duplicate phrases within a document
 
Join Date: Jan 2011
Posts: 8
bianson is on a distinguished road
Default

Just the quote and the author but both would be duplicated. I am not sure if I answered your question properly?
Reply With Quote
  #4  
Old 05-28-2018, 07:08 PM
macropod's Avatar
macropod macropod is offline Identify duplicate phrases within a document Windows 7 64bit Identify duplicate phrases within a document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,342
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

What you haven't said is how the content is formatted and how the author names are separated from the quotations to which they refer (e.g. are they in the same paragraph, or is there a paragraph break between them).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-28-2018, 07:37 PM
Guessed's Avatar
Guessed Guessed is offline Identify duplicate phrases within a document Windows 10 Identify duplicate phrases within a document Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,158
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Probably not. There is a good chance that there are minor differences which make many 'duplicates' not exactly the same.

But you could arrange the data in a way so that it could be sorted alphabetically and then you could either eyeball the duplicates or run a macro to highlight exact matches.

It all depends on what your document is structured like and how consistent that structure is.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #6  
Old 05-28-2018, 08:09 PM
macropod's Avatar
macropod macropod is offline Identify duplicate phrases within a document Windows 7 64bit Identify duplicate phrases within a document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,342
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

One could probably copy/paste the content into Excel, then sort it there. Any exact or near duplicates are likely to be sorted together. One could then locate & delete the corresponding duplicates in Word via Find.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to highlight duplicate phrases in document? taw Word VBA 0 02-27-2018 01:47 PM
Combine "sort within groups" and "identify duplicate/unique values" in two different variables. civilcervant Excel 3 06-12-2017 07:27 AM
Find duplicate phrases in textboxes throughout presentation leaning PowerPoint 2 06-06-2017 05:08 AM
Identify duplicate phrases within a document How to find duplicate phrases/paragraphs in a long document iamgator Word VBA 5 12-27-2016 01:34 AM
Identify duplicate phrases within a document Identify certain text and move all phrases containing it down a line Chayes Word VBA 2 11-26-2013 01:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft