I think the failure is in those programs that won't accept the long lines--but
if you look through the documentation, you may find that it's not a
failure--it's a feature.

Dave wrote:

(Sorry on slow response, too many plates, not enough sticks to spin them on)

Thanks, I will give that a try. Maybe I'll find something. I wish I could
find the exact failure so I could mitigate it!

"Dave Peterson" wrote:

Try viewing the file in WordPad on multiple computers. What do you see?

I think it's a limitation of NotePad and Informatica. But if you don't believe
that, search for a hex editor that will show you what's in those strings.




Dave wrote:

So, that you're aware of, there's no 1024 per line limit then? It's odd I
see the break in Notepad (before I send the file on) at the exact point that
Informatica also reports the line error.

I'm more than willing to go with Informatica being the break point, but with
Notepad doing the same thing, on multiple computers, it points to Excel as
the error point.

"Dave Peterson" wrote:

Your data seems to follow the CSV rules nicely.

It's informatica that's having trouble. I bet you have no control how that
works. So you'll have to live by its rules.

And I bet that one of its rules is the length of strings it accepts (just a
guess).

On the other hand, maybe there's a forum dedicated to Informatica that can give
you some hints/workarounds.

Dave wrote:

Having the same problem in the import of the data though (which uses a
program called Informatica), so it's not just Notepad. Notepad just happens
to show it. Oddly enough, Wordpad does not.

"Dave Peterson" wrote:

I think it's a limitation of notepad.

You could try importing a small portion of data into your application to see if
works ok.

Or you could search for a different text editor.

I've never used this one (that I recall), but NotePad+ (search google) has
gotten good reviews.

And Wordpad.exe looks like you can see the whole logical line on one physical
line.



Dave wrote:

I'm reviewing it in Notepad, and it's showing the data failing exactly where
it is in the system taking the text import (Informatica). I have confirmed
it's not a line feed nor carriage return. Replacing the cell contents with
nothing but a string of numbers (012345678901234567890 etc) has the exact
same effect after 1024 characters.
<text snip

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson