It is still easy with your example in consideration. you can go upto the ' after which there is a ,. but still yes it is not easy with some incorrect string inside the quote like
23,'That'',s too bad','',987,'' Sonty On Jan 20, 2:11 am, Michael Moore <[email protected]> wrote: > 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- Hide quoted text - > > - Show quoted text -
-- 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
