Re: substr instr
- From: Vladimir Andreev <vandreev@xxxxxxxxx>
- To: rjoralist@xxxxxxxxxxxxxxxxxxxxx
- Date: Fri, 31 Jul 2009 10:08:41 +0200
>
> But not in v9 that the OP's using...
>
> Rich
Drat! Missed that one small detail :-(
Oh well... let's try to lose the InStr()s and SubStr()s altogether:
with demo as (select 'Start net counter : 203542, 201282' x from dual)
select rtrim(rtrim(ltrim(x,'Start net counter :'),'0123456789 '),',') result
from demo;
albeit with caveats:
a) the constant prefix should contain no other characters than those in
LTrim's first parameter and definitely no digits
b) the data may contain at most one number and no commas after the first
comma
c) I'm not at all sure a couple of InStr()s and a SubStr() would be slower
than three Trim()s (or alternatively a Replace() and two Trim()s, as Jaromir
pointed out), but I have no V9i to test.
Cheers!
Flado
Other related posts: