How to add a blank line between every word in a list? - WickedFire - Affiliate Marketing Forum

cowsgonemad · 10-15-2011, 05:07 PM

Hi guys,

Couldn't think of anywhere else to put this..

So I have a list of 1000 words - I want to add a blank line between each word

for example my list looks like this

_______
hello
hi
what
pizza
_____________

I wanna make it

________
hello

hi

what

pizza
________________

I would go crazy if I tried to do it manually, and I have more lists that I need this done with as well..

So is there any tool, script, excel or word command or whatever which can get this done on the fly? Any help would be really appreciated..

megatabbers · 10-15-2011, 05:09 PM

This would be quite easy to whip up w/ some PHP. Post the job on Fiverr.

potentialeight · 10-15-2011, 05:23 PM

This will take about 5 minutes including download and installation if you don't have Notepad++ already.

Step 1: Get Notepad++.
Step 2: Load one of your text files.
Step 3: Go to Macro -> Start Recording.
Step 4: Start on the far left of the first line and press down then enter.
Step 5: Go to Macro -> Stop Recording.
Step 6: Go to Macro -> Save Current Recorded Macro. Name it line spacer or something.
Step 7: To use the macro, start at the beginning of one your text files. Then go to Macro -> Run a Macro Multiple Times, choose your macro name from the pull down list, and then choose the Run until the end of file radio button.

You'll only need to do Step 7 for future files.

liesnillusions · 10-15-2011, 05:25 PM

dreamweaver can do that easy with the search and replace feature

jryan21 · 10-15-2011, 05:33 PM

find '\n'
replace with '\n\n'

or '\r\n'->'\r\n\r\n'
for windows format

Hammi · 10-15-2011, 05:42 PM

Quote:

Originally Posted by jryan21

find '\n'
replace with '\n\n'

or '\r\n'->'\r\n\r\n'
for windows format

This is the easiest way. notepad++ can do find/replace for linebreaks and tabs.

Jizzlobber · 10-15-2011, 05:49 PM

Paste all the data into Column "A" in Excel.

Create this Macro:

Code:

Sub InsertRowAfterEveryRowWithEntryInColA()
'Ist declare your variable "Cell"
Dim Cell As Range 
'Set it's start value - this determines what column is checked
Set Cell = Range("A2")
'set a loop endpoint = when it reaches a blank cell
Do Until Cell = ""
'Insert a row
Cell.EntireRow.Insert
'Go to next row
Set Cell = Cell.Offset(1, 0)
'Repeat loop (goes back to the "Do" line
Loop
'Finishes when it reaches 1st blank cell in column A
End Sub

Select the entire column and the run the macro.

Hypnotic · 10-15-2011, 05:59 PM

Quote:

Originally Posted by jryan21

find '\n'
replace with '\n\n'

or '\r\n'->'\r\n\r\n'
for windows format

This.

LOL at the other comments. PHP? Macros? For this?

megatabbers · 10-15-2011, 06:44 PM

Quote:

Originally Posted by Hypnotic

This.

LOL at the other comments. PHP? Macros? For this?

You're so right... Can't believe Notebook slipped my mind LOL PHP!

Jizzlobber · 10-15-2011, 07:19 PM

Quote:

Originally Posted by Hypnotic

This.

LOL at the other comments. PHP? Macros? For this?

LOL at the blank line between posts expert.

nickCR · 10-15-2011, 09:10 PM

Quote:

Originally Posted by jryan21

find '\n'
replace with '\n\n'

or '\r\n'->'\r\n\r\n'
for windows format

This +++

10-15-2011, 05:07 PM	#1 (permalink)
cowsgonemad Senior Member Join Date: Jun 2010 Location: Behind a proxy Posts: 621 iTrader: 43 / 100%	How to add a blank line between every word in a list? Hi guys, Couldn't think of anywhere else to put this.. So I have a list of 1000 words - I want to add a blank line between each word for example my list looks like this _______ hello hi what pizza _____________ I wanna make it ________ hello hi what pizza ________________ I would go crazy if I tried to do it manually, and I have more lists that I need this done with as well.. So is there any tool, script, excel or word command or whatever which can get this done on the fly? Any help would be really appreciated.. Share Share this post on Digg Del.icio.us Technorati Twitter

10-15-2011, 05:09 PM	#2 (permalink)
megatabbers Senior Member Join Date: Jul 2009 Location: Boston, MA Posts: 1,285 iTrader: 3 / 100%	This would be quite easy to whip up w/ some PHP. Post the job on Fiverr. Share Share this post on Digg Del.icio.us Technorati Twitter __________________ "I have always believed that writing advertisements is the second most profitable form of writing," said BBDO Chairman Philip Dusenberry. "The first, of course, is ransom notes."

10-15-2011, 05:23 PM	#3 (permalink)
potentialeight Quality Content Writer Join Date: Oct 2010 Location: NC Posts: 989 iTrader: 11 / 100%	This will take about 5 minutes including download and installation if you don't have Notepad++ already. Step 1: Get Notepad++. Step 2: Load one of your text files. Step 3: Go to Macro -> Start Recording. Step 4: Start on the far left of the first line and press down then enter. Step 5: Go to Macro -> Stop Recording. Step 6: Go to Macro -> Save Current Recorded Macro. Name it line spacer or something. Step 7: To use the macro, start at the beginning of one your text files. Then go to Macro -> Run a Macro Multiple Times, choose your macro name from the pull down list, and then choose the Run until the end of file radio button. You'll only need to do Step 7 for future files. Share Share this post on Digg Del.icio.us Technorati Twitter __________________ High-Quality Content Writer $3 per 100 words, discount rates available http://www.potentialeight.com

10-15-2011, 05:25 PM	#4 (permalink)
liesnillusions Banned Join Date: Oct 2009 Posts: 391 iTrader: 0 / 0%	dreamweaver can do that easy with the search and replace feature Share Share this post on Digg Del.icio.us Technorati Twitter

10-15-2011, 05:33 PM	#5 (permalink)
jryan21 WF Premium Member Join Date: Nov 2007 Posts: 3,134 iTrader: 0 / 0%	find '\n' replace with '\n\n' or '\r\n'->'\r\n\r\n' for windows format Share Share this post on Digg Del.icio.us Technorati Twitter

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode