Macro to fix different error typos

[Fonsi]

Hi there,


I´m looking for a macro that makes the following fixes in a document:


1. Any double dot at the end of a sentence should be replaced by a single dot.

For example:

Hello world.. >>> Hello world.

2. Dot + space + dot at the end of a sentence should be replaced by a single dot.


For example:

Hello world. . >>> Hello world.

3. word + double space + word should be replaced by replaced by a single space:


For example:

Hello world >>> Hello world

Not sure if using wildcards will allow to do that in a single macro but will be very appreciated if so!

[macropod]

You don't need a macro, just a fewFind/Replace operations, where:

Find = ..
Replace = .

Find = . .
Replace = .
Find = ^32^32
Replace = ^32
You could, of course, record these as a macro.

[Paul_Hossler]

Hi there,

1. Any double dot at the end of a sentence should be replaced by a single dot.

2. Dot + space + dot at the end of a sentence should be replaced by a single dot.

3. word + double space + word should be replaced by replaced by a single space:



Single macro could do all that, but it's the 'end of a sentence' part that is a little tricky

End of a paragraph part is easy, but it is possible to have a Dot+space+Dot somewhere NOT at the end of sentence (maybe unlikely, but possible)

Maybe you could just assume a-z or 0-9 is the last character in the sentence




Sub Macro1()
With ActiveDocument.Content.Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = "([a-z0-9]).{2,}"
.Replacement.Text = "\1."
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchAllWordForms = False
.MatchSoundsLike = False
.MatchWildcards = True

.Execute Replace:=wdReplaceAll

.Text = "([a-z0-9]). {1,}."
.Execute Replace:=wdReplaceAll

.Text = " {2,}"
.Replacement.Text = " "
.Execute Replace:=wdReplaceAll
End With
End Sub