How can I remove spaces from line breaks?

Ztak07

Power Member

Jr. VIP

Jun 23, 2012

539

135

• Feb 23, 2013

• #1

I have a very big document but I have only one problem

The documents has over 1 million lines but a lot of them are empty.

They look like :

xxxxxxxx

xxxxxxx




xxxxxxxx
xxxxxxx

xxxxxxxx

I want them to look like :
xxxxxxx
xxxxxxx
xxxxxxxx
xxxxxxxx
xxxxxxxxx
xxxxxxxx

with no extra whitespace. Anyone know how to do this? Tried in excel but the file way to big

 

Blakester

Supreme Member

Mar 17, 2012

1,245

1,425

• Feb 23, 2013

• #2

http://textmechanic.com/Remove-Empty-Lines.html

 

jascoken

Senior Member

Nov 1, 2010

1,135

753

• Feb 23, 2013

• #3

... Or use any good text editor and search and replace any double line-breaks with a single line-break. As it is recurring, it will remove all blank lines. NotePad2 allows you to search and replace on codes like /n/n and replace with /n. This won't work with lines with spaces on them though.

 

SeoTube

BANNED

Jun 8, 2012

308

307

• Feb 23, 2013

• #4

serch on Google "Remove Empty Lines".. Google show you good result

 

AnnaCh

Newbie

Feb 9, 2013

47

15

• Feb 28, 2013

• #5

I'm not sure that will it be work with large file or not,

Using : Notepad
- copy all your text and paste to notepad
- at notepad, just press Ctrl+A to select all, then Alt+R to remove blank lines // this step may take a few minutes or longer for large file
- Finally, copy your text from notepad and paste back to your excel

 

D

Deleted member 264944

Guest

• Mar 1, 2013

• #6

non breaking space tag "google it"

 

Gogol

Administrator

Staff member

Moderator

Executive VIP

Jr. VIP

Sep 10, 2010

11,838

26,690

• Mar 1, 2013

• #7

Extremely easy... Go to your dreamweaver:

Press control + F which will bring up the find and replace box..

Select Find in "Current document"
Check the "Use regular expression" checkbox in Option.
In the find box type "[\r\n]{2,}" without quotes.
In the Replace box type "\n" without quotes

Click Replace All and you are done

EDIT: Use notepadd++ if DW hangs..
For Notepad ++ users, press ctrl+h, select the Regular Expression checkbox and do the same...

 

K

kingtana

Regular Member

Nov 1, 2008

277

74

• Mar 1, 2013

• #8

You might need a text file splitter

 

O

opsil

Newbie

Oct 16, 2012

22

6

• Mar 1, 2013

• #9

If you have excel, just paste the all text to a list. Then select all lines and use "delete duplicates".

 

seeplusplus

Power Member

Aug 18, 2008

525

179

• Mar 1, 2013

• #10

Won't Notepad do it? Just highlight * a * empty line whatever and use replace, just leave the replace with field empty. I do this all the time with gEdit.