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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2007-06-07 : 05:46:39
|
| Hi,I want to trim new line from string in sql server 2005...I prepared one dtsx package and in that I want to trim new line from one of my column but i am unable to do that.for example:I want to retrive one column name DESCRIPTION and put that in text file but along with it I am getting blank space and new line also that I want to trim...T.I.A |
|
|
JBelthoff
Posting Yak Master
173 Posts |
Posted - 2007-06-07 : 11:33:43
|
You might need to do a script task. So in VB.Net it would be this.Dim strString As String 'If this is your returnd string.strString = strString.Replace(Environment.NewLine, "") Or something like that.JBelthoff• Hosts Station is a Professional Asp Hosting Provider• Position SEO can provide your company with SEO Services at an affordable price› As far as myself... I do this for fun! |
 |
|
|
|
|
|
Trimming new line from text string in SSIS package