Home » SQL & PL/SQL » SQL & PL/SQL » regexp_replace (merged 2)
regexp_replace (merged 2) [message #679374] |
Wed, 26 February 2020 14:25 |
|
akarra
Messages: 24 Registered: August 2011 Location: Housston
|
Junior Member |
|
|
Hi I have a requirement
like below
create table test
(id number(4),keystg varchar2(1000));
REM INSERTING into EXPORT_TABLE
SET DEFINE OFF;
Insert into test (keystg,id) values ('1.1 1.1 1.1 1.1 tesddddt ',1090);
Insert into test (keystg,id) values ('1.2 1.2 1.2 1.2 ddfddddd111f v',1124);
Insert into test (keystg,id) values ('1.3 1.3 1.3 1.3 tes1111t ',1125);
Insert into test (keystg,id) values ('1.4 1.4 1.4 1.4 tesdddfft ',1126);
Insert into test (keystg,id) values ('1.5 1.5 1.5 1.5 te2323st ',1127);
Insert into test (keystg,id) values ('1.6 1.6 1.6 1.6 dtedfdfd123st',1128);
Insert into test (keystg,id) values ('1.7 1.7 1.7 1.7 stset2345 ',1129);
Insert into test (keystg,id) values ('1.8 1.8 1.8 1.8 sf 9094444',1130);
Insert into test (keystg,id) values ('1.9 1.9 1.9 1.9 dfdsf',1131);
Insert into test (keystg,id) values ('1.10 1.10 1.10 teeee NB 911',1151);
Insert into test (keystg,id) values ('1.11 1.11 ter1234 inr testere',1152);
commit;
select id,REGEXP_REPLACE(keystg,':digit:'),keystg from test
when i see the output it is removing all number including numbers in string.
coming output is for eg.
ID KEGSTG KEYSTG without regexp
1151 . . . teeee NB 1.10 1.10 1.10 teeee NB 911
expected is
ID KEGSTG KEYSTG without regexp
1151 teeee NB 911 1.10 1.10 1.10 teeee NB 911
can you please advise
thanks.
|
|
|
regexp_replace [message #679375 is a reply to message #679374] |
Wed, 26 February 2020 14:25 |
|
akarra
Messages: 24 Registered: August 2011 Location: Housston
|
Junior Member |
|
|
Hi I have a requirement
like below
create table test
(id number(4),keystg varchar2(1000));
REM INSERTING into EXPORT_TABLE
SET DEFINE OFF;
Insert into test (keystg,id) values ('1.1 1.1 1.1 1.1 tesddddt ',1090);
Insert into test (keystg,id) values ('1.2 1.2 1.2 1.2 ddfddddd111f v',1124);
Insert into test (keystg,id) values ('1.3 1.3 1.3 1.3 tes1111t ',1125);
Insert into test (keystg,id) values ('1.4 1.4 1.4 1.4 tesdddfft ',1126);
Insert into test (keystg,id) values ('1.5 1.5 1.5 1.5 te2323st ',1127);
Insert into test (keystg,id) values ('1.6 1.6 1.6 1.6 dtedfdfd123st',1128);
Insert into test (keystg,id) values ('1.7 1.7 1.7 1.7 stset2345 ',1129);
Insert into test (keystg,id) values ('1.8 1.8 1.8 1.8 sf 9094444',1130);
Insert into test (keystg,id) values ('1.9 1.9 1.9 1.9 dfdsf',1131);
Insert into test (keystg,id) values ('1.10 1.10 1.10 teeee NB 911',1151);
Insert into test (keystg,id) values ('1.11 1.11 ter1234 inr testere',1152);
commit;
select id,REGEXP_REPLACE(keystg,':digit:'),keystg from test
when i see the output it is removing all number including numbers in string.
coming output is for eg.
ID KEGSTG KEYSTG without regexp
1151 . . . teeee NB 1.10 1.10 1.10 teeee NB 911
expected is
ID KEGSTG KEYSTG without regexp
1151 teeee NB 911 1.10 1.10 1.10 teeee NB 911
can you please advise
thanks.
|
|
|
|
|
Re: regexp_replace [message #679378 is a reply to message #679377] |
Wed, 26 February 2020 14:35 |
|
akarra
Messages: 24 Registered: August 2011 Location: Housston
|
Junior Member |
|
|
CREATE TABLE test (
id NUMBER(4),
keystg VARCHAR2(1000)
);
REM INSERTING into EXPORT_TABLE
SET DEFINE OFF;
Insert into test (keystg,id) values ('1.1 1.1 1.1 1.1 tesddddt ',1090);
Insert into test (keystg,id) values ('1.2 1.2 1.2 1.2 ddfddddd111f v',1124);
Insert into test (keystg,id) values ('1.3 1.3 1.3 1.3 tes1111t ',1125);
Insert into test (keystg,id) values ('1.4 1.4 1.4 1.4 tesdddfft ',1126);
Insert into test (keystg,id) values ('1.5 1.5 1.5 1.5 te2323st ',1127);
Insert into test (keystg,id) values ('1.6 1.6 1.6 1.6 dtedfdfd123st',1128);
Insert into test (keystg,id) values ('1.7 1.7 1.7 1.7 stset2345 ',1129);
Insert into test (keystg,id) values ('1.8 1.8 1.8 1.8 sf 9094444',1130);
Insert into test (keystg,id) values ('1.9 1.9 1.9 1.9 dfdsf',1131);
Insert into test (keystg,id) values ('1.10 1.10 1.10 teeee NB 911',1151);
Insert into test (keystg,id) values ('1.11 1.11 ter1234 inr testere',1152);
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sat Jun 08 03:04:47 CDT 2024
|