[thelist] replacing line breaks in sql 2000
Joshua Olson
joshua at waetech.com
Fri Dec 21 07:30:26 CST 2007
> -----Original Message-----
> From: Brian Cummiskey
> Sent: Friday, December 21, 2007 12:30 AM
>
> Joshua Olson wrote:
> > What error is it throwing? If there's no error, what is
> the problem you are
> > having?
>
> No error, it exports correctly.
>
> However, it's just proving to be a pain for the 3rd party to
> import it,
> as they are looking for the CR\LF at the end of the line. The line
> breaks within the data are causing the file to not import properly on
> their end.
>
> See screen shot:
> http://i8.tinypic.com/86pgv1v.jpg
Brian,
That's not brakcets [], that's a box--meaning a single character that is not
within the range of printable characters. Open this file in a hex editor to
see what character it is. (try editpad or notepad++)
Joshua
More information about the thelist
mailing list