Welcome to WebmasterWorld Guest from 54.146.217.179

Forum Moderators: phranque

Message Too Old, No Replies

Notepad++ & Excel

copy html from notepad and paste in excel

     
5:57 am on Jul 19, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Apr 13, 2003
posts:66
votes: 0


I want to be able to edit small amout of html in notepad++ and then copy and paste into excel for upload to a mysql database...
the code is simple

<b>Title</b>
<ul>
<li>Strong enough to take all the weight you can carry.</li>
<li>Your gear will stay dry </li>
<li>No need to carry a liner</li>
<li>Exclusive non-slip waist buckle able to handle any load. </li>
<li>Folds down to a waistbag </li>
<li>The short pile won't catch grass seeds and stays looking great year after year</li>
<li>Comfortable underload with foam lined hip area</li>
</ul>
<b>Specifications</b>

The only problem is that excel will not take it without formating it...somehow i need to remove returns and tabs....has anyone run into this problem before?
6:05 am on July 19, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Apr 13, 2003
posts:66
votes: 0


sorry for extra post
what i meant was my data is jumping down the excel colum into other cells.
I just want on string of text in one cell that has html tags in it.
8:32 am on July 19, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 14, 2003
posts:1550
votes: 0


if you want all that code into one cell remove all the carriage return from the code ie. in notepad ++ you'd have:

<b>Title</b><ul><li>Strong enough to take all the weight you can carry.</li><li>Your gear will stay dry </li><li>No need to carry a liner</li><li>Exclusive non-slip waist buckle able to handle any load. </li><li>Folds down to a waistbag </li><li>The short pile won't catch grass seeds and stays looking great year after year</li><li>Comfortable underload with foam lined hip area</li></ul><b>Specifications</b>

10:29 pm on July 19, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Apr 13, 2003
posts:66
votes: 0


Thank You that is exactly the result i want.

BUT is there a way to quickly remove carrige returns in notepad++ rather than go through the whole lot manually?

Gecko

12:45 pm on July 20, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 14, 2003
posts:1550
votes: 0


yes what you have to do is go at the end of the first line with your mouse and place the cursor there.
click and drag the selection to the first character on the second line.
hit 'ctrl + h'

the search and replace box should appear with squares in the search for box / drop down

hit replace all and it will remove all the carriage returns.

12:48 pm on July 20, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 14, 2003
posts:1550
votes: 0


I just found that doing

'ctrl + a' select all
'ctrl + j' join lines

is even quicker