By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
REGEXP_SUBSTR('H-HENRYGREY;CA;UID123;09870;','H-([^;]+)',1,1,NULL,1) |
---|
Henry Grey |
REGEXP_SUBSTR('H-HENRYGREY;CA;UID123;09870;','H-([^;]+)',1,1,NULL,1) |
---|
Henry Grey |