Oracle function that extends the functionality of the SUBSTR function by allowing searching a string for a regular expression pattern. See also REGEXP_INSTR, REGEXP_REPLACE, REGEXP_LIKE and REGEXP_COUNT for other functions extended to use regular expressions.
Questions tagged [regexp-substr]
353 questions
-2
votes
1 answer
SQL: using regexp_substr ot regexp_extract, looking for the regex pattern that will only return the string between one character and a space
The row I am trying to parse from is a series of string values separated only by spaces. Sample below:
TX:123 SP:XapZNsyeS INST:456123
I need to use either regexp_substr or regexp_extract to return only values for the string that appears after…
eps
- 1
-2
votes
1 answer
Query to split using Regexp data split not getting correct result oracle SQL
I am trying to classify the tables into various categories ,but i was not able to get the desired result , please check the below query results , existing results along with the expected results
STANDARD
NON_STANDARD
TEMPORARY
TO_BE_DROPPED
SELECT…
Data2explore
- 452
- 6
- 16
-2
votes
4 answers
Mobile Number should start from 3 in Oracle SQL and also check length should be 10
I have mobile numbers in Oracle table column whose datatype is string
3451111111
923452222222
03451111211
I want SQL statement to select mobile numbers in this form 3451111113 only and check the length = 10.
I want a sub string that starts from…
ali419
- 5
- 4
-2
votes
2 answers
String Values till last comma (Maximum 20 Chars) in Oracle
I have a requirement to make data in oracle as below:
Condition :- Values till last comma (Maximum 20 Chars).
Data | Length | Output
----------------------------------------------------
12,34,abc,D,eva,096,qwerty | 26 |…
Nishant Gupta
- 19
- 2
-2
votes
2 answers
REGEXP_SUBSTR for portion of string
I would like to get:
82961_01B04WZXQQSUGJ4YMRRT2A7TRHK_MR_2_1of1
from the following expression
LASTNAME_FIRSTNAME_82961_01B04WZXQQSUGJ4YMRRT2A7TRHK_MR_2_1of1
Does someone know how I can get this using regexp_substr ?
EDIT
Basically I have a field…
aquaz_mi
- 11
- 1
-2
votes
1 answer
RegExp to match anyname/anynamewithid/date/string
I want to write a regular expression to match the given pattern
anyname/anyname2/anydate/string
anyname: It must accept valid names including underscore (_)
anyname2: It must accept valid names including underscore(_) or hiffen (-)
anydate: The date…
Arjun Kesava
- 740
- 1
- 10
- 14
-3
votes
2 answers
Regexp substr in oracle
Concerta 18 mg/24 hr oral tablet, extended release
Expected Output
tablet, extended release
Input
glipiZIDE 10 mg oral tablet, extended release
Expected Output
tablet, extended release
Input
Adderall XR 10 mg oral capsule, extended…
Sqllearner
- 1
- 2
-3
votes
2 answers
Regular Expression - Replace set of String with value in oracle
Please any one can give some idea , how to replace set of String with value in Oracle .eg :-
String Formula: (20+OFR)/(10-OGR)
need to Replace OFR=100 and OGR=50 .
String Formula is dynamically changing.
Expected result (20+OFR)/(10-OGR)=…
Rohit Kumar
- 5
- 2