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