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

"Ed Prochak" <edprochak_at_adelphia.net> wrote in message news:3E8C5ADD.6090908_at_adelphia.net...
> 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
>

unfortunately I have just started ? why ? can you direct me to some samples ? Received on Thu Apr 03 2003 - 10:14:58 CST