Loading ...
Sorry, an error occurred while loading the content.

Re: [NTB] Proper text coding for using in Excel to prevent the HTML code from displaying?

Expand Messages
  • Get Sprays
    Hello John, I just tried the test again and it also displays the HTML code. What i need is teh code to stay on one line and not to execute. to be sure i did
    Message 1 of 16 , Sep 10, 2010
    • 0 Attachment
      Hello John,

      I just tried the test again and it also displays the HTML code. What i need
      is teh code to stay on one line and not to execute.

      to be sure i did what you ask: i saved the HTML code within NT as ascii/DOS
      text. that was the closest format to DOS/Windows I saw in the Save As
      option.

      what do you think/

      thanks,
      billy


      On Tue, Sep 7, 2010 at 11:21 AM, John Shotsky <jshotsky@...> wrote:

      >
      >
      > Did you TRY what I said?
      >
      > Regards,
      > John
      >
      > -----Original Message-----
      > From: notetab@yahoogroups.com <notetab%40yahoogroups.com> [mailto:
      > notetab@yahoogroups.com <notetab%40yahoogroups.com>] On Behalf Of Get
      > Sprays
      > Sent: Monday, September 06, 2010 04:06
      > To: notetab@yahoogroups.com <notetab%40yahoogroups.com>
      > Subject: Re: [NTB] Proper text coding for using in Excel to prevent the
      > HTML code from displaying?
      >
      > Please find several files for review. thanks for the help.
      >
      > later,
      > billy
      >
      > On Thu, Sep 2, 2010 at 7:16 PM, John Shotsky <jshotsky@...<jshotsky%40comcast.net>>
      > wrote:
      >
      > >
      > >
      > > As I mentioned earlier, you can eliminate that possibility by copying the
      > > text from one doc and
      > > pasting to a new one, then saving it, with the default save as
      > Dos/Windows.
      > > I have had to do that on
      > > many occasions. If it works, you know that is what the problem was. It is
      > a
      > > VERY simple
      > > troubleshooting step, and can also just let you get on with your chore.
      > >
      > > Regards,
      > > John
      > >
      > > From: notetab@yahoogroups.com <notetab%40yahoogroups.com> <notetab%
      > 40yahoogroups.com> [mailto:
      > > notetab@yahoogroups.com <notetab%40yahoogroups.com> <notetab%
      > 40yahoogroups.com>] On Behalf Of Eb
      > > Sent: Thursday, September 02, 2010 15:59
      > > To: notetab@yahoogroups.com <notetab%40yahoogroups.com> <notetab%
      > 40yahoogroups.com>
      > > Subject: Re: [NTB] Proper text coding for using in Excel to prevent the
      > > HTML code from displaying?
      > >
      > >
      > >
      > > This is beginnig to sound like some control characters like form feed, or
      > > nulls from Unicode, are
      > > being converted or erased by Word, but not by NoteTab. Try toggling
      > > "preserve Unicode" in NoteTab
      > > options.
      > >
      > > Anyway, why not post some of the offending html text, so we can try to
      > > duplicate your problem. Make
      > > sure it is a sample that you have experienced the problem with, straight
      > > from notetab.
      > >
      > > I routinely paste columns of numbers and text from NTP 6.2 to Excel
      > without
      > > problems.
      > >
      > > Eb
      > >
      > > --- In notetab@yahoogroups.com <notetab%40yahoogroups.com> <notetab%
      > 40yahoogroups.com> <mailto:
      > > notetab%40yahoogroups.com <notetab%2540yahoogroups.com>> , Get Sprays
      > > <getsprays.wtj@...>
      > >
      > > wrote:
      > > >
      > > > thanks for your help.
      > > >
      > > > no it MS Office professional 2010. also, its not XML as i can recognize
      > > > that format. what's strange is that if i paste into MS Word and then
      > save
      > > > as text and then paste into Excel it works. but once it lands in NT Pro
      > 6
      > > > it often will not paste or isnert into Excel anymore.
      > >
      > > [Non-text portions of this message have been removed]
      > >
      > >
      > >
      >
      > --
      > Get Sprays - William
      > getsprays.wtj@... <getsprays.wtj%40gmail.com>
      > Georgia, USA
      >
      > ----------
      >
      > <p><font style="font-family: trebuchet ms,sans-serif; font-style: italic;
      > font-weight: bold;"
      > size="3"><font style="color: rgb(153, 51, 0);" size="4">MAX Professional�
      > 1113 Blow Off� General
      > Purpose Air Duster Cleaner, BO-111-113 (8 oz)</font></font><font
      > style="font-family: trebuchet
      > ms,sans-serif; font-style: italic;" size="3"><span style="font-weight:
      > bold;"><font style="color:
      > rgb(153, 51, 0);" size="4"><br></font><br></span></font></p><div
      > style="margin-left: 40px;">
      > <p><font style="font-family: trebuchet ms,sans-serif; font-style: italic;"
      > size="3"><span
      > style="font-weight: bold;">Blow Off� General Purpose Air Duster, Flammable
      > 8 oz</span></font> <span
      > style="font-family: trebuchet ms,sans-serif;">removes dust, dirt and
      > microscopic debris from hard to
      > reach areas of home and office equipment. It's ozone safe.</span><br><span
      > style="font-family:
      > trebuchet ms,sans-serif;"></span><br><span style="font-family: trebuchet
      > ms,sans-serif;"><span
      > style="font-weight: bold;">Recommended For:</span> Computers </span><span
      > style="font-family:
      > trebuchet ms,sans-serif;">� </span><span style="font-family: trebuchet
      > ms,sans-serif;">Keyboards �
      > Sewing Machines � Photo Equipment � Cash Registers � Printers � Fax
      > Machines � Copiers � Telephones
      > � Lab Equipment � TVs � VCR � Typewriters � Vacuums � Scanners � Stereos �
      > Watches � Clocks �
      > Mailing Machines � Fans � Audio Equipment � Electric Razors � Sports
      > Equipment � Musical Instruments
      > � Guns � Desk Tops</span><br><span style="font-family: trebuchet
      > ms,sans-serif;"></span><br>
      > </p></div><span style="font-family: trebuchet ms,sans-serif;"><font
      > style="color: rgb(102, 102,
      > 102);" size="2">SKU: 1113<br>Mfg. Pn: </font></span><font style="color:
      > rgb(102, 102, 102);"
      > size="2"><span style="font-family: trebuchet
      > ms,sans-serif;">BO-111-113</span><br></font><span
      > style="font-family: trebuchet ms,sans-serif;"><font style="color: rgb(102,
      > 102, 102);" size="2">UPC:
      > 752080111113<br>Pkg: 8 oz Aerosol<br><br></font></span><font size="2"
      > face="Verdana"><hr></font><div
      > style="text-align: left;"><font size="3" face="Trebuchet
      > MS"><p><strong><span style="color: rgb(255,
      > 0, 0); font-style: italic;">Restrictions On VOC Compounds Shipping Into The
      > State Of
      > California</span><br></strong></p></font><div style="margin-left: 40px;
      > font-weight: bold;"><font
      > size="2" face="Trebuchet MS">This spray product contains VOC compounds and
      > meets the State of
      > California Standards (Prop65) and therefore cannot be shipped into the
      > State of
      > California.</font></div><p style="margin-left: 40px;"><font size="2"
      > face="Trebuchet MS">If you are
      > interested, please contact MAX-Tech-Sprays� via email for more details on
      > the shipping of this
      > item.</font></p></div><hr><span style="font-family: trebuchet
      > ms,sans-serif;"></span>
      > ----------
      >
      > ���<!DOCTYPE html MAX-Tech-Sprays��� ��2010 "-//W3C//DTD HTML 4.01
      > Transitional//EN"><html><head><title></title></head><body><p><font
      > style="font-family: trebuchet
      > ms,sans-serif; font-style: italic; font-weight: bold;" size="3"><font
      > style="color: rgb(153, 51,
      > 0);" size="4">MAX-Professional��� 1113 Blow Off��� General Purpose Air
      > Duster Cleaner, BO-111-113 (8
      > oz)</font></font><font style="font-family: trebuchet ms,sans-serif;
      > font-style: italic;"
      > size="3"><span style="font-weight: bold;"><font style="color: rgb(153, 51,
      > 0);"
      > size="4"><br></font><br></span></font></p><div style="margin-left:
      > 40px;"><p><font
      > style="font-family: trebuchet ms,sans-serif; font-style: italic;"
      > size="3"><span style="font-weight:
      > bold;">Blow Off��� General Purpose Air Duster, Flammable 8 oz</span></font>
      > <span
      > style="font-family: trebuchet ms,sans-serif;">removes dust, dirt and
      > microscopic debris from hard to
      > reach areas of home and office equipment. It's ozone
      > safe.</span><br><br><span style="font-family:
      > trebuchet ms,sans-serif;"><span style="font-weight: bold;">Recommended for:
      > </span> Computers</span>
      > <span style="font-family: trebuchet ms,sans-serif;">•</span> <span
      > style="font-family:
      > trebuchet ms,sans-serif;">Keyboards • Sewing Machines • Photo
      > Equipment • Cash
      > Registers • Printers • Fax Machines • Copiers •
      > Telephones • Lab Equipment
      > • TVs • VCR • Typewriters • Vacuums • Scanners
      > • Stereos •
      > Watches • Clocks • Mailing Machines • Fans • Audio
      > Equipment • Electric
      > Razors • Sports Equipment • Musical Instruments • Guns
      > • Desk
      > Tops</span><br><br></p></div><span style="font-family: trebuchet
      > ms,sans-serif;"><font style="color:
      > rgb(102, 102, 102);" size="2">SKU: 1113<br>Mfg. Pn:</font></span> <font
      > style="color: rgb(102, 102,
      > 102);" size="2"><span style="font-family: trebuchet
      > ms,sans-serif;">BO-111-113</span><br></font><span style="font-family:
      > trebuchet
      > ms,sans-serif;"><font style="color: rgb(102, 102, 102);" size="2">UPC:
      > 752080111113<br>Pkg: 8 oz
      > Aerosol<br><br></font></span><hr><div style="text-align: left;"><p><font
      > size="3" face="Trebuchet
      > MS"><strong><span style="color: rgb(255, 0, 0); font-style:
      > italic;">Restrictions On VOC Compounds
      > Shipping Into The State Of California</span><br></strong></font></p><div
      > style="margin-left: 40px;
      > font-weight: bold;"><font size="2" face="Trebuchet MS"><b>This spray
      > product contains VOC compounds
      > and meets the State of California Standards (Prop65) and therefore cannot
      > be shipped into the State
      > of California.</b></font></div><p style="margin-left: 40px;"><font size="2"
      > face="Trebuchet MS">If
      > you are interested, please contact MAX-Tech-Sprays��� via email for more
      > details on the shipping
      > of this item.</font></p></div><hr></body></html>
      >
      > [Non-text portions of this message have been removed]
      >
      > ------------------------------------
      >
      > Fookes Software: http://www.fookes.com/
      > NoteTab website: http://www.notetab.com/
      > NoteTab Discussion Lists: http://www.notetab.com/groups.php
      >
      > ***
      > Yahoo! Groups Links
      >
      >
      >



      --
      Get Sprays - William
      getsprays.wtj@...
      Georgia, USA


      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.