Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replace multiple duplicate character into One

ChuongNguyenMar 6 2017 — edited Mar 6 2017

Dear gurus,

I have Detail Column which contain string like this .

";;;;;;;;;;;;;;;;;;;;;Tên Khách hàng : Nguyen Van A;;;;;Mã CIC : 98785729463;;;;;Địa chỉ : 6999, ĐƯỜNG NGUYỄN CHÍ THANH ;;;;;Khách hàng hiện không có quan hệ tại TCTD;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;© 2015CICB"

Now, for cleansing data, i want to remove/replace all semi-colon character become to only one semi-colon. Like below result

";Tên Khách hàng : Nguyen Van A;Mã CIC : 98785729463;;;;;Địa chỉ : 6999, ĐƯỜNG NGUYỄN CHÍ THANH ;Khách hàng hiện không có quan hệ tại TCTD;2015CICB"

Is there any idea on this

So thanks and apprecite.

Chuong
This post has been answered by AndrewSayer on Mar 6 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 3 2017
Added on Mar 6 2017
4 comments
448 views