Data Mining

Download Free Data Mining Source Code In C/C++, C#, Visual Basic, Visual Basic.NET, Java,
and other programming languages

Welcome to Data Mining Sign in | Join | Help

Home

Blogs

Forums

Photos

My Reader

Data Mining Source Code Newsletter

Subscribe By Email | Subscribe By RSS Feed

Business Analyst Training
Live, Online, Video Courses
Instructor-Led + Hands-On
BusinessAnalystBootCamp.Com

SQL + Database Training
Live, Online, Video Classes
Instructor-Led + Hands-On
SQLBootCamp.Com

Software Developer Training
Live, Online, Video Courses
Instructor-Led + Hands-On
SoftwareDevelperBootCamp.Com

IT CAREER COACH
Hands-On Experience Coaching
IT Skills Training
IT-Career-Coach.NET

IT Professional Newsletter
"Free" IT Career Success Tips
How To Accelerate Your Career
IT Career Newsletter

Ask IT Career Questions
"ASK" A Burning IT Career
Question Or Get Answers
Ask A Burning IT Question Now!

Data Mining » Data Mining » Data Mining With SPSS Clementi... » Removing "Carriage Returns" from strings

Announcing The Data Mining Source Code Newsletter!

Subscribe By Email | Subscribe By RSS Feed

Removing "Carriage Returns" from strings

Last post 03-20-2009, 10:15 by Singing Banzo. 1 replies.


	Sort Posts: Previous Next

03-17-2009, 8:40 8742

Scot Land
Joined on 03-17-2009
New Member

Removing "Carriage Returns" from strings

I have text in a field which appears to have carriage returns. When I copy them out from a table into Excel I get the string on several lines rather than in one cell. I can remove some by using a replace("\n","XXXXX",@FIELD), (I have put XXXXX in to show where the replace is working but normally it would be blank) but this does not remove them all. Any ideas ?