[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