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
    I have not been able to determine what format within NT to use so it will directly paste into one line in an Excel call. With Word I do not have to even save
    Message 1 of 16 , Sep 10, 2010
    • 0 Attachment
      I have not been able to determine what format within NT to use so it will
      directly paste into one line in an Excel call. With Word I do not have to
      even save the file. i drop it in Word and ^C and then ^V into an Excel cell
      and it works.

      have you been able to repeat what i am seeing?

      how can i get attached files to you? the forum will not allow me to do so.

      sorry but what steps did you ask me to try? I think i did try them.

      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]
    • 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 2 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.