{"id":56273,"date":"2008-02-05T22:39:00","date_gmt":"2008-02-05T22:39:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2008\/02\/05\/hey-scripting-guy-how-can-i-count-the-number-of-sentences-and-paragraphs-in-an-office-word-document\/"},"modified":"2008-02-05T22:39:00","modified_gmt":"2008-02-05T22:39:00","slug":"hey-scripting-guy-how-can-i-count-the-number-of-sentences-and-paragraphs-in-an-office-word-document","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/hey-scripting-guy-how-can-i-count-the-number-of-sentences-and-paragraphs-in-an-office-word-document\/","title":{"rendered":"Hey, Scripting Guy! How Can I Count the Number of Sentences and Paragraphs in an Office Word Document?"},"content":{"rendered":"

\"Hey, <\/p>\n

Hey, Scripting Guy! I just read your article<\/b><\/a> about getting Word documents statistics and would like to know if there is any way of getting the number of sentences and paragraphs per document.<\/p>\n

— RLP<\/p>\n

\"Spacer\"\"Hey,\"Script<\/a> <\/p>\n

Hey, RLP. To be perfectly honest, now that the Super Bowl is over the Scripting Guy who writes this column is more relieved than he is happy. The Scripting Guy who writes this column is not a New York Giants fan, and under normal circumstances he would never ever<\/i> root for the Giants. <\/p>\n\n<\/thead>\n\n\n
\n

Note<\/b>. But suppose alien invaders showed up on Earth, challenged the Giants to a football game, and said they would destroy the planet if the Giants lost; wouldn\u2019t the Scripting Guy who writes this column root for the Giants if the very fate of the Earth was at stake?<\/p>\n

You know what? That\u2019s probably not going to happen, so maybe we shouldn\u2019t even speculate on that.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/div>\n

As many of you know, however, this year\u2019s Super Bowl was not played under normal circumstances; instead, the New England Patriots were on the brink of being declared the greatest football team \u2013 heck, the greatest sports team \u2013 heck, the greatest collection of human beings who ever lived or ever will live. The New England<\/i> Patriots<\/i>? Say it isn\u2019t so! The truth is, the Scripting Guy who writes this column just couldn\u2019t deal with that prospect. Therefore, with desperate times calling for desperate measures, he bit his lip, held his nose, and rooted for the New York Giants. <\/p>\n

And, surprisingly enough, the Giants actually won. Which figures. The teams that the Scripting Guy who writes this column really, truly roots for \u2013 the Washington Huskies, the Seattle Mariners, the Seattle Seahawks \u2013 never<\/i> seem to win. But the team he roots for merely as the lesser of two evils, well, they win.<\/p>\n

But, still, anyone but the Patriots, right?<\/p>\n

Well, no, not the Dallas Cowboys; no way. The Oakland Raiders? Heavens no! And, no, not the New York Jets; we don\u2019t really like the Jets. And definitely not \u2026. <\/p>\n

At any rate, it was an exciting game, and a lot of fun to watch. As for the rest of the day\u2019s festivities, the Scripting Guy who writes this column (as always) skipped the pregame shows; he made dinner during the halftime show (although he does<\/i> like Tom Petty and the Heartbreakers); and he had a lot of trouble figuring out the meaning behind most of the … innovative \u2026 commercials that were telecast during the game. In fact, if anyone can explain why watching a dog slurp from a water bowl for 30 seconds makes you want to rush out and buy Gatorade, well, drop us a line<\/b><\/a> and let us know.<\/p>\n

While we wait for than explanation we might as well see if we can solve RLP\u2019s problem. (We have a feeling it\u2019s going to be awhile before anyone can come up with anything.) Before we show you any code, however, we need to note that today\u2019s task is more difficult than you might think; in fact, depending on your point of view, it might be downright impossible. For example, how many sentences would you say are in the following paragraph:<\/p>\n\n\n\n
\u2022<\/td>\n\n

The highlight of the evening was an appearance by Dr. Ken Myer.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Most people would say there\u2019s just one sentence here. However, Microsoft Word is going to insist that there are two<\/i> sentences. Why? Because in Word\u2019s view a sentence consists of an ending punctuation mark (like a period, question mark, or exclamation mark) followed by a blank space or paragraph return. Consequently, Word thinks the preceding paragraph contains two sentences:<\/p>\n\n\n\n\n
\u2022<\/td>\n\n

The highlight of the evening was an appearance by Dr. <\/p>\n<\/td>\n<\/tr>\n

\u2022<\/td>\n\n

Ken Myer.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

To be honest, there\u2019s no good way to work around this problem, at least not until computers fully understand English. That means that Word (or any custom regular expression you try to come up with) is almost always going to overestimate the number of sentences in a document. That\u2019s something you\u2019ll just have to learn to live with.<\/p>\n\n<\/thead>\n\n\n
\n

Note<\/b>. One thing you could<\/i> do is a run a few tests using typical Word documents. You might find that, for you documents, Word consistently says there are 5% more sentences than there really are. In that case, you could add some code that automatically makes that adjustment when reporting back the number of sentences in a document. But, needless to say, that\u2019s up to you.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/div>\n

The point is, sentences can pose a bit of a problem. Paragraphs can also pose a problem, albeit a completely different one. For example, how many paragraphs do you see in the following selection, with the underscore indicating each time we pressed the ENTER key:<\/p>\n

Paragraph 1._
_
Paragraph 2._
_
Paragraph 3._<\/p>\n

As you might have guessed, the answer is this: it depends. If you use the ComputeStatistics<\/b> method to calculate the number of paragraphs (like we did in our original article<\/b><\/a>), Word will tell you that there are three paragraphs here. If you use the Paragraphs<\/b> collection, however (which we\u2019re going to use today) then Word will tell you that there are five<\/i> paragraphs in this document. Why? Because in that case Word is simply counting the number of times you pressed the ENTER key. How did we insert a blank line between paragraphs? That\u2019s right: we hit the ENTER key. In fact, we hit the ENTER key five times, which is why the Paragraphs collection contains five items. So which of these two values \u2013 three or five \u2013 is correct? That really depends both on you and on the nature of your documents. <\/p>\n

But you know what? There\u2019s no reason why you can\u2019t use both approaches in your script. In fact, why don\u2019t we do just that? Why don\u2019t<\/i> we use both paragraph-counting methods in our script:<\/p>\n

Const wdStatisticParagraphs = 4Set objWord = CreateObject(\"Word.Application\")objWord.Visible = TrueSet objDoc = objWord.Documents.Open(\"C:\\Scripts\\Test.doc\")Wscript.Echo \"Paragraphs (text-only): \" & objDoc.ComputeStatistics(wdStatisticParagraphs)Wscript.Echo \"Paragraphs (including blank lines): \" & objDoc.Paragraphs.CountWscript.Echo \"Sentences: \" & objDoc.Sentences.Count<\/pre>\n
As you can see, we start things off by defining a constant named wdStatisticParagraphs and setting the value to 4; that tells Word which kind of statistic we want it to compute. After defining the constant we create an instance of the Word.Application<\/b> object; set the Visible<\/b> property to True (just so we can see our instance of Word on screen); and then use this line of code to open the document C:\\Scripts\\Test.doc:<\/p>\n
Set objDoc = objWord.Documents.Open(\"C:\\Scripts\\Test.doc\")<\/pre>\n
To make it a little easier for you to follow along at home, here\u2019s what Test.doc looks like:<\/p>\n
The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog.
The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog.
The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog.<\/p>\n
By the way, here\u2019s a cool little Word trick. Create a new, blank document, type the following, and then press ENTER:<\/p>\n
=rand()\u202a<\/pre>\n
When you do that, Word will add the preceding text into your document. (In Word 2007 the text will be different, but thre function still works.) In other words, =rand() <\/b>will add a bunch of sample text into your document, giving you a practice document that actually has some text in it. Would you like a document that has 8 paragraphs, and would you like each of those paragraphs to have 3 sentences in it? Then type the following and press ENTER:<\/p>\n
=rand(8,3)\u202a<\/pre>\n
And you thought all we did was write scripts. The truth is, every now and then we actually know something that doesn\u2019t<\/i> involve scripting.<\/p>\n
And yes, that usually is<\/i> something about as important as knowing how to insert sample text into a Word document.<\/p>\n
After we\u2019ve opened our document we\u2019re ready to calculate the number of paragraphs and sentences. To count only the paragraphs that actually contain text we use this line of code:<\/p>\n
Wscript.Echo \"Paragraphs (text-only): \" & objDoc.ComputeStatistics(wdStatisticParagraphs)<\/pre>\n
In this case, the script is going to tell us that the document contains 3 paragraphs; that\u2019s because we have three paragraphs that actually contain text. To count the number of times we hit the ENTER key, we simply report back the value of the Paragraph collection\u2019s Count<\/b> property, a property that tells us the number of items in the collection:<\/p>\n
Wscript.Echo \"Paragraphs (including blank lines): \" & objDoc.Paragraphs.Count<\/pre>\n
This time around Word will tell us that the document contains 4<\/i> paragraphs; that\u2019s because the blank line following paragraph 3 is considered a paragraph. Finally, we can use the Count property of the Sentences<\/b> collection to determine the number of sentences in the document:<\/p>\n
Wscript.Echo \"Sentences: \" & objDoc.Sentences.Count<\/pre>\n
Because this is a very straightforward little document (i.e., it doesn\u2019t contain abbreviations or any other misleading punctuation marks) Word correctly tells us that the document contains 15 sentences. Like we said, depending on the nature of your document Word won\u2019t always be able to tell you exactly how many sentences there are. In this case, it hit the nail right on the head. In other cases \u2026.<\/p>\n
That\u2019s about the best we can do, RLP. It\u2019s far from perfect, but we don\u2019t really know of any foolproof way to get at this information. But, remember, the important thing isn\u2019t whether or not you can count the sentences in a Word document with 100% accuracy. The important thing is that the New England Patriots lost the Super Bowl.<\/p>\n
We\u2019ll just try to ignore the fact that, if the Patriots lost, that must mean that the Giants won. <\/p>\n\n<\/thead>\n\n\n
\n
Note<\/b>. Of course, now that the Super Bowl is over there\u2019s only one big game left: the 2008 Winter Scripting Games<\/b><\/a>. Remember, the Games start on Friday, February 15th<\/sup>. Whatever you do, don\u2019t miss them; after all, nobody wants to see the Giants win the Scripting Games, too.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! I just read your article about getting Word documents statistics and would like to know if there is any way of getting the number of sentences and paragraphs per document. — RLP Hey, RLP. To be perfectly honest, now that the Super Bowl is over the Scripting Guy who writes this column […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[84,49,3,5],"class_list":["post-56273","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-microsoft-word","tag-office","tag-scripting-guy","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! I just read your article about getting Word documents statistics and would like to know if there is any way of getting the number of sentences and paragraphs per document. — RLP Hey, RLP. To be perfectly honest, now that the Super Bowl is over the Scripting Guy who writes this column […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/56273","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=56273"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/56273\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=56273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=56273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=56273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}