It was just for testing to highlight the difference. 2010/1/20 Michael Moore <[email protected]>
> Not really sure why you would want to replace the embedded single-quote > with an X. > > Anyway, like I said, I already wrote some code that does what I want. > > Thanks, > Mike > > > On Wed, Jan 20, 2010 at 7:05 AM, Javier Montani <[email protected]>wrote: > >> Did you try using "replace"? >> Try this: >> create table test (t varchar2(10)); >> insert into test values ('pp'||''''||'s'); >> select t from test; >> select replace(t,'''','X') from test; >> select replace(t,'''','') from test; >> >> >> 2010/1/20 sonty <[email protected]> >> >> 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 >>> >> >> >> -- >> 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 >
-- 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
