Re: Having problem with SPLIT


"Bryan Oakley" <oakley@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:hpYwe.2534$cb6.745@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Earl Grieda wrote:
> > ...
> > The problem started when I thought it would be nice to have HTML
> > and/or tabs in a header, so I tested it to see if it works. But,
> > "split" changes the word "\tHeader" to {\tHeader},
>
> That is an incorrect assessment. Believe it or not, split will *not*
> add any characters to the original data. Internally the header does
> not contain those curly braces. Split is not what is causing the {}'s
> to appear in your data.
>
> The problem comes when you use this list as a string. When you do that
> (such as when you do a puts), tcl automatically converts the list to a
> string.

Yes. (Light bulb goes off.) Problem solved. The error was in the proc that
writes the headers to the report. As you mentioned, I was trying to "puts"
a list, not a string.


.

Relevant Pages

  • Re: Is it possible for me to have an alert pop-up when I open a do
    ... them and clean up the whole header. ... Dim TheWeekOfStr As String ... After I enabled macros and changed the security level, as per Dave Peterson, ... I got almost what I wanted, except that the pop-up box contains the font ...
    (microsoft.public.excel.misc)
  • Re: Zero terminated strings
    ... For doing major string handling you want a language where strings are a ... Check the header bytes as they are coming in and assume that you have dropped at least one byte if any of them are wrong. ... When you have a complete valid message (at the final destination, however many hops down the line it is) the final destination acknowledges it, and keeps sending ACKs for it until it receives the next message. ... The sender keeps trying to send it until it gets the acknowledgment. ...
    (comp.lang.c)
  • Re: Compile Error (ADO) Ron De Bruin
    ... Public Sub GetData(SourceFile As Variant, SourceSheet As String, _ ... Dim rsData As ADODB.Recordset 'THE ERROR IS ALWAYS HERE ... If Header = False Then ...
    (microsoft.public.excel.programming)
  • Re: Error With ADO (Starting to pull my hair out)
    ... 'It will copy the Header row also ... Public Sub GetData(SourceFile As Variant, SourceSheet As String, _ ... Dim rsData As ADODB.Recordset ...
    (microsoft.public.excel.programming)
  • Re: Error With ADO (Starting to pull my hair out)
    ... 'It will copy the Header row also ... Public Sub GetData(SourceFile As Variant, SourceSheet As String, _ ... Dim rsData As ADODB.Recordset ...
    (microsoft.public.excel.programming)