Regular Expressions 101

Positive Lookbehind(?<=where)

wherethe literal text where (case insensitive)

Group 1(.*?)

.*?any character, repeated any number of times

1st AlternativeORDER BY

ORDER BYthe literal text ORDER BY (case insensitive)

2nd AlternativeGROUP BY

GROUP BYthe literal text GROUP BY (case insensitive)

3rd AlternativeHAVING

HAVINGthe literal text HAVING (case insensitive)

4th AlternativeLIMIT

LIMITthe literal text LIMIT (case insensitive)

5th AlternativeOFFSET

OFFSETthe literal text OFFSET (case insensitive)

6th Alternative$

$end of string, or before its final line terminator

.*any character, repeated any number of times

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

s modifier: single line. Allows a dot to match line terminators

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(?<=where)(.*?)((ORDER BY|GROUP BY|HAVING|LIMIT|OFFSET|$).*)

Test String
New

select "DIM_1"."col1",
"DIM_2"."col2" ,
"DIM_3"."col3" , 
"DIM_4"."col4" , 
"FAT_1"."col5"     
from "FAT_1",
 "DIM_1",
 "DIM_2",
 "DIM_3",
 "DIM_4"
where  "DIM_1"."col1" IS NOT NULL 
AND "DIM_2"."col2" LIKE ('SUCCESS')
AND "DIM_3"."col3" BETWEEN 20161213 AND 20161222
AND "DIM_4"."col4" > 0
ORDER BY DIM_1.col1

Regular Expression

Test StringNew

ExtractionProcessing...

Test String
New

Extraction
Processing...