parsing out EOL markers from a string field

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

parsing out EOL markers from a string field

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-02-18 : 08:31:59

Doug writes "I have hit a wall on this one. Please help!!

I am attempting to extract rows from the SQL server that contain a column with a string datatype. Within this column can be any text including EOL or CR markers. How can I parse through this column during my SQL extraction to remove or replace the EOL or CR markers?

Thanks alot for the help!!!!

-Doug "

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-18 : 08:55:44

select replace(columnName, 'MarkerName', ''), other columns
from MyTable

Go with the flow & have fun! Else fight the flow

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-02-18 : 10:48:16

for control characters:
replace(col,char(9),'') -- replace tab
replace(col,char(10),'') -- replace nl
replace(col,char(13),'') -- replace cr
replace(col,char(10)+char(13),'') -- replace eol

rockmoose

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources