homepage Welcome to WebmasterWorld Guest from 54.166.108.167
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
Forum Library, Charter, Moderators: phranque

Website Technology Issues Forum

    
Notepad++ & Excel
copy html from notepad and paste in excel
gecko001




msg:3014046
 5:57 am on Jul 19, 2006 (gmt 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?

 

gecko001




msg:3014056
 6:05 am on Jul 19, 2006 (gmt 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.

le_gber




msg:3014153
 8:32 am on Jul 19, 2006 (gmt 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>

gecko001




msg:3015099
 10:29 pm on Jul 19, 2006 (gmt 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

le_gber




msg:3015736
 12:45 pm on Jul 20, 2006 (gmt 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.

le_gber




msg:3015738
 12:48 pm on Jul 20, 2006 (gmt 0)

I just found that doing

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

is even quicker

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved