Hello,
I want to get all the initials, without spaces, without dots, without small characters.
with t as (
select 1 rn, 'P. P. P.' initials from dual union
select 2 rn, 'A.T-J.' initials from dual union
select 3 rn, 'C,' initials from dual union
select 4 rn, 'Th. C.' initials from dual union
select 5 rn, 'B. Test' initials from dual union
select 6 rn, 'B.A.' initials from dual union
select 7 rn, 'E. F.' initials from dual
)
select REGEXP_SUBSTR(initials, '[A-Z]( |.){1}+', 1, 1)
from t
the result will be.
1 PPP
2 AT
3 C
4 TC
5 BT
6 BA
7 EF
Thanks in advance.
L.