1

Topic: Specific word or the character in line

Whether there is such function  searches for a specific word or the character in line in sampling.
For example sampling of a line 1000*1150*88558*5554454, only number (result of sampling) 88558

2

Re: Specific word or the character in line

RTFM Character Functions Returning Character Values (FAQ)

3

Re: Specific word or the character in line

Function INSTR (str, search_str [n [m]])
Function INSTR returns a position of first m-ro character of a fragment of a line str, coinciding with line search_str. Comparing is conducted from n th character of a line str, at comparing the register is considered. By default n = m = 1, that is search is conducted from the beginning of a line and the position of the first found fragment is returned. In case of unsuccessful search function returns 0.

4

Re: Specific word or the character in line

982183;
In ms sql is parsename a finds a specific word, in  did not find similar function or how to register syntax, help

5

Re: Specific word or the character in line

wrote:

it is passed...
Show, please, usage parsename on the example.

select PARSENAME (REPLACE (column, ' * ', '. '), 2)

6

Re: Specific word or the character in line

all on  is multiple, it is necessary to make
1000051*1000008*1011*1000212*1003815
1000051*1000008*1011*1000212*1003833
1011 on 1012 all remaining remains  only 1011 on 1012
Result
1000051*1000008*1012*1000212*1003815
1000051*1000008*1012*1000212*1003833

7

Re: Specific word or the character in line

Goofy122;
update

8

Re: Specific word or the character in line

select replace (' 1000051*1000008*1011*1000212*1003815 ', '*1011 * ', '*1012 * ')
from dual

9

Re: Specific word or the character in line

ABOUT;
Thanks and how in Update ?

10

Re: Specific word or the character in line

Goofy122;
To register a script

11

Re: Specific word or the character in line

Goofy122 wrote:

thanks and how in Update ?

Absolutely a zero without a stick?

12

Re: Specific word or the character in line

Goofy122;

with t as (
select level as lv, regexp_substr (s, '\d + ', 1, level, ' m ') words
from (select ' 1000*1150*88558*5554454 ' s from dual)
connect by regexp_substr (s, '\d + ', 1, level, ' m ') is not null
)
select *
from t
where lv=3;

13

Re: Specific word or the character in line

All thanks the big understood