On Oct 25, 7:17*am, sparks wrote:
On Fri, 21 Oct 2011 10:29:43 -0500, sparks wrote:
I put it into notepad.
did the import and it is still putting it into the same format I put
into notepad.
it is wrapping at IV....the same 255 limit i had in the originail
file.
will try some more.

On Fri, 21 Oct 2011 05:17:35 -0700 (PDT), Andrew
wrote:

On Oct 21, 5:56*am, sparks wrote:
This is what is weird...I guess its backwards compatibility or
something.

the file is an xlsx but it is wrapping at IV I guess for excel 97 so
we checked and it has about 8000 time values...can the newer excel go
that high?

we end up with a single sheet that looks like this (quick cut and
paste not what we have) over and over until the end of its time cycle..

10/17/2011 4:24:20 4:24:35 4:24:50 4:25:05 4:25:20
BOB1 * * * 125 * * 122 * * 120 * * 123 * * 111
BOB2 * * * 0 * * * 0 * * * 0 * * * 0 * * * 0
BOB3 * * * * * * * * * *0 *0 * * * 0 * * * 0 * * * -0.1I
10/17/2011 4:24:20 4:24:35 4:24:50 4:25:05 4:25:20
BOB1 * * * 125 * * 122 * * 120 * * 123 * * 111
BOB2 * * * 0 * * * 0 * * * 0 * * * 0 * * * 0
BOB3 * * * * * * * * * *0 *0 * * * 0 * * * 0 * * * -0.1I
10/17/2011 4:24:20 4:24:35 4:24:50 4:25:05 4:25:20
BOB1 * * * 125 * * 122 * * 120 * * 123 * * 111
BOB2 * * * 0 * * * 0 * * * 0 * * * 0 * * * 0
BOB3 * * * * * * * * * *0 *0 * * * 0 * * * 0 * * * -0.1I

IF it was a single row of data a quick transpose and we are done.

Copy your excel sheet into notepad. *Then in excel, import the data
from text. *Don't try to copy and paste. *Use the data import function
which is under the data tab. *Then once the import begins, import as
"delimited", using a space for the delimiter.

I tried what isabelle posted and this is what I get.

varname = BOB1
date = 10/17/2011
time = 04:24:20
value = 125

varname = *BOB1
date = 10/17/2011
time = 04:24:35
value = 122

varname = BOB2
date = 10/17/2011
time = 04:24:20
value = 0

varname = BOB2
date = 10/17/2011
time = 04:24:35
value = 0

not sure why it is reading 2 entries or the blank lines.

=============
I tried the notepad but it still sees the wrap at 255.

I told them I needed data that was NOT word wrapped like this.
They are blaming the program for the data saying its backwards
compatible for older versions.

I told them get me the data or convert it yourself. Dont know how far
that is going to go.

they push a button and get it and then its my fault. Typical

Would you mind sending the data. I'd like to take a look at it.