Removing double empty lines (two 0x0a 0x0a in a row)

MACRO: REMOVEEMPTYLINES

PURPOSE: To remove double empty lines (two 0x0a 0x0a in a row)

WHY: When converting from mac/unix/dos text file formats some programs stuff up by making double lines which is annoying

HOW: Just mark your area and run the macro

Sub RemEmptyLines()
 Dim comp
 str = ActiveDocument.Selection.Text
 str1 = ""
 comp = vbLf + vbLf
 comp2 = vbLf + vbLf
 i = 1
 Do While (i < Len(str)+1)
 Do While Mid(str, i, 2) = comp
 i = i + 1
 Loop
 str1 = str1 + Mid(str, i, 1)
 i = i + 1
 Loop
 ActiveDocument.Selection.Text = str1
End Sub

Date Last Updated: February 1, 1999



Comments

  • nice example

    Posted by Legacy on 07/06/2002 12:00am

    Originally posted by: kirankumar


    Nice, but i want paragraph funcations any examples is there please infoam my mail id

    my problem is starting of document to space finishing of the file two spaces.


    please sir
    your friend

    Reply
  • Nice, but destroys the nice formatting

    Posted by Legacy on 05/11/1999 12:00am

    Originally posted by: Yonat

    This is really useful, but it deletes double new lines even 
    
    when you don't want too (ie, when the original file
    containes empty lines).

    Here is my own version, which just deletes every second line:

    Sub DelEvenLines()
    'DESCRIPTION: Delete all even lines in a file. Useful for files where MSDev turned every LF to an empty line.
    ActiveDocument.Selection.StartOfDocument
    currLine = 1
    prevLine = 0
    Do While currLine > prevLine
    ActiveDocument.Selection.LineDown
    If ActiveDocument.Selection.Text = "" Then
    ActiveDocument.Selection.Delete
    End If
    prevLine = currLine
    currLine = ActiveDocument.Selection.CurrentLine
    Loop
    End Sub

    Reply
Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • Companies undertaking an IT project need to find the right balance between cost and functionality. It's important to start by determining whether to build a solution from scratch, buy an out-of-the-box solution, or a combination of both. In reality, most projects will require some system tailoring to meet business requirements. Decision-makers must understand how much software development is enough and craft a detailed implementation plan to ensure the project's success. This white paper examines the different …

  • Remember getting your first box of LEGOS as a kid? How fun it was putting the pieces together, collaborating with your friends to create something new? Now, as an IT professional, assembling and maintaining a Lego-like collaboration infrastructure isn't what you signed up for. Piecing together disparate systems of record for email, web meetings and other applications is about as painful as stepping on a pile of Legos. Download the e-book to learn how implementing a collaboration system connects systems of …

Most Popular Programming Stories

More for Developers

RSS Feeds

Thanks for your registration, follow us on our social networks to keep up-to-date