Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-18-2014, 12:31 AM
macropod's Avatar
macropod macropod is offline Finding duplicate sentences in a document Windows 7 32bit Finding duplicate sentences in a document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,363
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

The first thing you need to be aware of is that Word VBA's notion of what constitutes a sentence isn't what most readers would consider a sentence. For example, consider the following:

Mr. Smith spent $1,234.56 at Dr. John's Grocery Store, to buy: 10.25kg of potatoes; 10kg of avocados; and 15.1kg of Mrs. Green's Mt. Pleasant macadamia nuts.

For you and me, that would probably count as one sentence; for VBA it counts as 5... So what you're regarding as long sentences might not be the same as your macro's interpretation.

Given the above, I'd suggest a different approach, which is to use a two-dimensional array, with the 2nd dimension holding the 'sentence' index. Then, instead of using Find/Replace, simply retrieve the 'sentence' index when needed and highlight that 'sentence'. Just don't be surprised if some of the matches are only parts of grammatical sentences.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
duplicate sentences, vba script



Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding duplicate sentences in a document Help with finding multiple keywords in a single document then highlight navyguy Word 2 01-03-2014 12:48 PM
Finding duplicate sentences in a document Finding or searching ^ character in word document shahin3121 Word 2 03-05-2012 06:16 PM
Finding duplicate sentences in a document keep only sentences beginning with: Wind Michael007 Word VBA 3 01-17-2011 04:11 PM
Finding where I last worked on a document. Balliol Word 1 11-24-2010 04:50 AM
Saving Word document creates a duplicate transparent file bbailey Word 0 12-05-2009 10:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:30 PM.


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