Re: remove character...

From: George Ziniewicz <zin1_at_cox.net>
Date: Mon, 1 Mar 2004 18:16:48 -0800
Message-ID: <TbR0c.5733$506.5243_at_fed1read05>

"Marc Collin" <os2_at_videotron.ca> wrote in message news:NKM0c.63859$QM4.1041253_at_weber.videotron.net...
> hi
>
> with plsql
> how to Remove N character in str1 starting from index I

haven't tried it but it looks ok:

newStr=

      substr(orig_str,1,I-1)||
      substr(orig_str,I+N);

zin
--- http://www.zintel.com Received on Tue Mar 02 2004 - 03:16:48 CET

This message: [ Message body ]
Next message: Mark C. Stock: "Re: Finding first saturday of month"
Previous message: Jim Kennedy: "Re: stored proc returning array"
In reply to: Marc Collin: "remove character..."
In reply to Marc Collin: "remove character..."
Next in thread: Ed prochak: "Re: remove character..."
Reply: Ed prochak: "Re: remove character..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message