sql – String seperation with oracle regexp
Need to separate the following long string using oracle regexp –
Row1 has following value-
‘van dam is brother of Prince Charles(12345). Mathew Perker is son of Prince Charles(12345).’
Row2- ‘Madam Currie is grandmother of Albert Eistine(56789). Pieer Currie is grandfather of Albert Eistine(56789). CV Raman is friend of Albert Eistine(56789).’
Now by split I need the following separate string –
From Row1 –
‘van dam is brother of Prince Charles(12345).’
‘Mathew Perker is son of Prince Charles(12345).’
From Row2-
‘Madam Currie is grandmother of Albert Eistine(56789).’
‘Pieer Currie is grandfather of Albert Eistine(56789).’
‘CV Raman is friend of Albert Eistine(56789).’
These seperate strings can be presented in separate column. The numbers in brackets are actually ID stored in ID field of the table.
Is it possible to achieve such split using oracle regexp?
Read more here: Source link
