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 dots with single dot

MaheshBApr 1 2016 — edited Apr 1 2016

Hi,

I have a column which has data like 1..2....3..4 and various variations.

I want to remove multiple occurrences of . (DOT) and keep single instance only.

Data we get can have any number of dots at any position. I want to replace multiple dots with single one.

Current Data	Expected Data
1.2….4.5	1.2.3.4
1……4…..5	1.4.5
1.2.3.4	1.2.3.4
1.2.3.4…….5….6……7	1.2.3.4.5.6.7

Above are some of the possible combinations.

How can i achieve this in SQL ?

Any inputs would be helpful.

Regards,

Mahesh

This post has been answered by Nimish Garg on Apr 1 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 29 2016

Added on Apr 1 2016

8 comments

3,224 views