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!

regexp_replace

RengudiAug 3 2022

Hi
greetings.

I want to replace the below string using regexp_replace anything other than alphanumeric, numeric,'_' and '.' should be replaced with '_' if continuous underscores are coming then only one underscore should be shown in the result.
input string
" s@tv#5-f_&c.m/06n-x(m)-n()c::s1-tr'd:zv85::re'ga*f|sr__g=in/k"
expected output string using regexp_replace
"s_tv_5-f_c.m_06n-x_m_-n_c_s1-tr_d_zv85_re_ga_f_sr_g_in_k"

Thanks
Rengudi

This post has been answered by Frank Kulash on Aug 3 2022

Jump to Answer

Added on Aug 3 2022

3 comments

168 views

1 mention