Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-08 : 08:04:35
|
| Pat writes "We have a SQL Server 2000 front end for collecting inquiries from our customers and these records are then exported as text to a flat file database that process them. The form basically has name, address, phone, country, etc... info. Every now and then, a Carriage Return is inserted after the street address field. I use Query Analyzer and dump the results to text and it is evident that there is a hard break in the record. We've looked at the code and there is nothing in it that would cause this. There is no white space, no crlf appended to the form data, nothing at all. This carriage return causes our secondary system to crash and that's a bad thing. Have you ever seen this before?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-01-08 : 08:06:09
|
| I've seen anomalies in text files before, but I'm wondering why you "have a SQL Server 2000 front end" and are exporting "to a flat file database that processes them". That's kinda backwards. Why not just have SQL Server do all the processing? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-08 : 12:48:38
|
| Dumping the results into text from Query Analyzer is not what you want to do. The carriage return might not even exist in your data. Query Analyzer could be adding the carriage return for viewing purposes. Dump the results into a file via bcp or DTS. I doubt that you'll find the carriage return.See this:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=31633Tara |
|
|
|
|
|
|
Line Breaks showing up in Record