Re: how to seperate a string on a certain position of a character (e.g:semikolon) in PLSQL

Filiz Duman wrote:
> I have a string e.g:
>
> cc_people := 'adam.white_at_xxx.com;andrew.guest_at_xxx.com;jim.whatever_at_yyy.com'
> .....
>
> how can I get each individualls email address out of here e.g
>
> adam.while_at_xxx.com
> andrew.guest_at_xxx.com
> jim.whatever_at_yyy.com
> .
> .
> .
> Any ideas how/which string operations to use ?
> Thanks in advance.
>
>

INSTR() to find where the field separators are, SUBSTR() to split the pieces out.

How long have you been a PL/SQL programmer?

-- 
Ed Prochak
running: http://www.faqs.org/faqs/running-faq/
family:  http://web.magicinterface.com/~collins
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost