While looking for "tokenizer functions" over the internet, I am really surprised how simply you can make your own tokenizer function with the functionality you want. Please see a sample function at link below: http://www.oracle.com/technology/oramag/code/tips2004/080904.html
and what I can suggest that just check if the first charater after delimiter, is a quote ' or " then change the sPattern to the quote temporarily and after selecting the text inside, reset the sPattern to the delimiter. I hope this will help. Regards, Sonty On Jan 16, 1:00 am, Michael Moore <[email protected]> wrote: > I can find a dozen plsql string tokenizer functions that do simple delimited > strings, but none that understand that the delimiter is NOT a delimiter when > it's in a quoted string. > > 14,'BANK,47',23 > > should return > 14 > BANK,47 > 23 > > not > 14 > 'BANK > 47' > 23 > > Would somebody link me to some code that does what I need? > > Thanks, > Mike
-- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
