Thanks Sonty, I already saw the one you linked. I ended up writing my own. Not quite as simple as you make it sound, but nothing insurmountable either.
consider 23,'That''s too bad','',987,'' Any, thanks for your reply! Regards, Mike On Sat, Jan 16, 2010 at 8:57 AM, sonty <[email protected]> wrote: > 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 >
-- 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
