Results 1 to 3 of 3
  1. #1
    ABW Ambassador leeann's Avatar
    Join Date
    January 18th, 2005
    Posts
    2,955
    Excel & Note Tab Question
    (Sorry if I put this on the wrong forum...please move for me, if I did - Thanks!) but here is the question.

    I am trying to convert 2500 records from excel to html. I know I can export it from excel to html, which works fine. I then open the document in Note Tab and I am then trying to strip the document of html coding, but preserve the urls. It won't save the URLs when I do this for some reason. Any suggestions? I tried saving the excel sheet in txt. but it doesn't show the URLs either, when I do that...so I'm at a standstill.

    Here is kinda what the excel sheet looks like: (JaneDoe.com is ficticious)
    JaneDoe $10 Off Visit JaneDoe.com

    When I convert it to html & open it in NoteTAb, it comes out like -

    <tr height=34 style='height:25.5pt'>
    <td height=34 class=xl26 width=169 style='height:25.5pt;border-top:none;
    width:127pt' bordercolor="#c0c0c0">JaneDoe</td>
    <td class=xl26 width=282 style='border-top:none;border-left:none;width:212pt'
    bordercolor="#c0c0c0">$10 Off </td>
    <td class=xl29 width=133 style='border-top:none;border-left:none;width:100pt'
    bordercolor="#c0c0c0"><a
    href="<A href="http://www.janedoe.com">Visit JaneDoe.com</a></td">http://www.janedoe.com">Visit JaneDoe.com</a></td>

    When I click for it to remove all HTML coding but preserve the URLs it comes out like this:
    JaneDoe $10 Off Visit JaneDoe.com

    What I want it to look like is:
    JaneDoe $10 Off http://www.janedoe.com Visit JaneDoe.com

    I can't figure out why it's deleting the URLS.

    Any help is appreciated.

    Thanks!

  2. #2
    ABW Ambassador beachcom's Avatar
    Join Date
    May 11th, 2006
    Location
    Myrtle Beach SC
    Posts
    723
    Try this

    <tr height=34 style='height:25.5pt'>
    <td height=34 class=xl26 width=169 style='height:25.5pt;border-top:none;
    width:127pt' bordercolor="#c0c0c0">JaneDoe</td>
    <td class=xl26 width=282 style='border-top:none;border-left:none;width:212pt'
    bordercolor="#c0c0c0">$10 Off </td>
    <td class=xl29 width=133 style='border-top:none;border-left:none;width:100pt'
    bordercolor="#c0c0c0"><a
    href="<A href="http://www.janedoe.com"Visit JaneDoe.com</a></td><td>http://www.janedoe.com</a>Visit JaneDoe.com</a></td>


    Hope this helps,
    Joey

  3. #3
    ABW Ambassador leeann's Avatar
    Join Date
    January 18th, 2005
    Posts
    2,955
    Thanks Beachcom, but I was trying to salvage the url when I convert an html file to a text file. I appreciate your effort to help, though! Thanks!

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Can you help with an Excel question?
    By zimmy in forum Midnight Cafe'
    Replies: 2
    Last Post: June 17th, 2006, 04:59 PM
  2. Excel tab-delimited export confuses WebMerge
    By cscull in forum WebMerge (Fourthworld.com)
    Replies: 2
    Last Post: March 4th, 2006, 12:18 PM
  3. Excel question
    By SSanf in forum Programming / Datafeeds / Tools
    Replies: 9
    Last Post: February 6th, 2006, 03:25 PM
  4. Excel question
    By netsu in forum Midnight Cafe'
    Replies: 2
    Last Post: January 31st, 2004, 06:31 PM
  5. Excel Question
    By ~Michelle in forum Midnight Cafe'
    Replies: 2
    Last Post: January 21st, 2004, 01:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •