Removing returns

[CDandVinyl]

Hi All


I use this code to search and replace a recurrent block of text in my documents :

Please Login or Register  to view this content.

It works well , but unfortunately it leaves some unevenly-spaced phrases with varying returns between them. Having found and removed the chunk of text in the search parameter , it's leaving a hole in the text.

For example:

Phrase 1

Phrase 2



Phrase 3


Phrase 4

Phrase 5


There should be only one blank line between each phrase , but in some cases these are now more than this. Sometimes there are two returns , sometimes three. Can someone suggest some code , or an amendment to the code above , to remove the extra returns so that there is only one blank line between phrases?

This would make the above example become even :

Phrase 1

Phrase 2

Phrase 3

Phrase 4

Phrase 5



Grateful for any advice.

[Aardigspook]

You could try a find-and-replace for two paragraph returns with one paragraph return (Find ^p^p Replace with ^p) and run that after your code. Use the same code as you have above, but with these entries instead of the find/replace you have:

Please Login or Register  to view this content.

If you have instances of three or four paragraph returns, repeat the wdReplaceAll line a few times at the end, to reduce four to three to two to one.

Please Login or Register  to view this content.

Once you've got everything down to single paragraph returns, if you want to have a blank line between each (and therefore need two para returns), you'll need to run it again (once only) but replace ^p with ^p^p.

Hope that makes sense!

[CDandVinyl]

Hi

Many thanks for your help. I gave it all a go with some success , but the issue remains a little defiant. I'm wondering if the extra lines caused by my search and replace are paragraph returns after all.

At any rate , I've attached a sample. Maybe this will help describe the issue more clearly.

It's the three returns between item 3 and item 4 I'm trying to reduce to one. All of the rest of the page is as it should be.

[Aardigspook]

You have some line breaks as well as paragraphs returns. You can see this if you turn on formatting marks. To do that, either press the 'show/hide' button on the Standard toolbar (normally just to the left of the % zoom box) or press Ctrl-Shift-8 (Ctrl-*).
The symbol for that in Find-and-Replace is ^l instead of ^p (that's a lower-case l for look not a one or an upper-case I for If).
So before doing the Find-Replace for ^p^p, first do one for Find ^l and Replace with ^p to convert all the line breaks to paragraph returns.

[CDandVinyl]

Excellent - that's fixed it. Problem solved!

[Aardigspook]

Glad I could help. Thanks for the rep and for marking the thread as Solved.