Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in01.usenetserver.com!news.usenetserver.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!transit.news.xs4all.nl!xs4all!textnews.nntp.hccnet.nl!textreader.nntp.hccnet.nl!not-for-mail From: sybrandb@hccnet.nl Newsgroups: comp.databases.oracle.server Subject: Re: String manipulations Date: Wed, 28 Mar 2007 00:05:37 +0200 Message-ID: <275j03hqnqp35oofdqo4skkcf2kufpo598@4ax.com> References: <1175017055.361915.129110@o5g2000hsb.googlegroups.com> <1175021923.375637.273130@n59g2000hsh.googlegroups.com> <1175022604.830583.274280@b75g2000hsg.googlegroups.com> X-Newsreader: Forte Agent 4.2/32.1118 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 22 Organization: Hobby Computer Club News Network NNTP-Posting-Date: 27 Mar 2007 22:05:56 GMT NNTP-Posting-Host: 62.251.43.174 X-Trace: 1175033156 textreader.nntp.hccnet.nl 736 62.251.43.174:4306 X-Complaints-To: abuse@hccnet.nl Xref: usenetserver.com comp.databases.oracle.server:424850 X-Received-Date: Tue, 27 Mar 2007 17:05:58 EST (text.usenetserver.com) On 27 Mar 2007 12:10:04 -0700, "nirav" wrote: >> >> To add one more details: the fourth row could be: >> Mohan (x,m,z) went to see Joe >> >> & so basically the three parameters inside the braces are all variable >> length varchar strings and in this example, it should change to: >> Mohan (x,m,'~'z) went to see Joe >> >One more detail: I am not on Oracle 10g, so can not use regular >expression..Oracle version :9.2.0.7. > In the time you post all this so-called 'detail', you could already have resolved it using instr, and substr. But alas, you rather want others to do your work. What if the internet broke down in your locale? -- Sybrand Bakker Senior Oracle DBA