Posted on 2011-03-11
I need to extract "lwf-gr-gg-abt1" from the following string in sql:
I want to use a regular expression such and tried the following without success:
select user_name, regexp_replace(group_name, 'CN=(.*),CN=(.*)','\1') from table
Do you have a regualr expression that will work for me?
Many thanks for your help and thoughts,