Welcome to WebmasterWorld Guest from 54.158.36.59

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)

10+ Year Member



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 Jul 19, 2006 (gmt 0)

10+ Year Member



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 Jul 19, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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 Jul 19, 2006 (gmt 0)

10+ Year Member



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 Jul 20, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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 Jul 20, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I just found that doing

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

is even quicker

 

Featured Threads

Hot Threads This Week

Hot Threads This Month