asked on

SQL TRIM duplicated Training characters

I have text strings that can look like any of these lines

String String String String 
String 
String String 
String String String 

What command would I uses to remove the trailing 's

Thanks

Guy Hengel [angelIII / a3]

presuming that the HTML code does not contain any € symbol on it's own (it should be € ...), this could do:

select replace(replace(rtrim( replace(replace(yourfield, ' ' , '€'), '<br />', ' '), ' ', '<br />'), '€', ' ')

Open in new window

cyberkiwi

case when right(strCol,6)=' ' then left(strCol,len(strCol)-6) else strCol end

Om Prakash

If you are using sql server then,

Update table_name
set
field_name = left(field_name,len(field_name) - 6)

ASKER CERTIFIED SOLUTION

cyberkiwi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cyberkiwi

My first solution takes the first trailing br away, 2nd takes all trailing br's away.
To fix angelIII's multi-replace method:

select
replace(
 replace(
 replace(
 rtrim(
 replace(
 replace(
 replace(
 strcol, ' ', CHAR(255))
 , ' ' , CHAR(254))
 , Char(255), ' ')
 )
 ,' ', char(255))
 ,char(254), ' ')
 ,char(255), ' ')
from tbl

darren-w-

ASKER

I found it easy to understand and implement, may have been difficult to understand from a beginners perspective though.