col value contains carriage return how to remove
NeilCSEDec 19 2007 — edited Dec 26 2007Hi All,
Certain values in col contains carriage(or it contains some space like char) return char how to remove them.
first how to find and then how to remove them.
say for eg.
it is sql server but logic remains same if you can post oracle answer will also do for me thanks in advance
select distinct ["Acquisition Cost (local currency)"],
len(["Acquisition Cost (local currency)"]) from
tableA
out put
"Acquisition Cost (local currency)" (No column name)
553 | 4
262 | 4
38 | 3
279 | 4
271 | 4
The above are 2 colum i have manually separated with | symbol to differentiate 2 cols
There are extra characters coming with actual data which I want to remove it.
kindly help.
Message was edited by:
user605246
Message was edited by:
user605246