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 |
|
GRAYWOLF
Posting Yak Master
106 Posts |
 Posted - 2009-03-05 : 04:27:17
|
| I have a Table that contains survey results. Sometimes the respondent will add CR or LF within a text window. This appears to be causing Excel to interpret this as the EOR and breaks the rest of the row to the next row. Is there an easy way to remove these characters before creating the CSV output file?---------------------------Working until "the morning sun sets the midnight sky on fire"! |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-03-05 : 05:53:58
|
| If insert is happening in a webpage / application - probably best to remove it there or else do an update of table to remove them.Remove char(13) and char(10) |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-05 : 12:30:01
|
| or try doing replace in T-sql using REPLACE() function |
|
|
|
|
|
|
Line break in SSIS output file