regex over multiple lines in Groovy

Question

I have a multiple line string like following:

END IF;

EXECUTE IMMEDIATE ' CREATE INDEX #idx1
      ON somename ( row_id,
                           something)';
   IF v_sys_error  0 THEN
      GOTO SQL_ERROR;

   END IF;

I wish to capture the part in bold (meaning everything from EXECUTE IMMEDIATE to next semicolon.

I have the following regex but how can I change it to work with multiple lines?

(EXECUTE).*;

score 82 · Accepted Answer · edited Apr 29 '20 at 13:12

82

(?m) makes the regex multiline - allows you to match beginning (^) and end ($) of string operators (in this case, to match the beginnings and ends of individual lines, rather than the whole string):

/(?m)(EXECUTE).*?;/

(?s) - dotall flag - makes the regex match newlines with . (dot) operators:

/(?s)(EXECUTE).*?;/

edited Apr 29 '20 at 13:12

mike rodent

14,126
11
103
157

answered Sep 01 '09 at 17:41

Nosrama

14,530
13
49
58

I thought that "regex match newlines with . (dot) operators" means that dot match only new line and not any other characters. Now I understand that it ADD new line to matching characters – danski88 Dec 17 '21 at 11:34

score 10 · Answer 2 · answered Sep 01 '09 at 20:09

10

The following should work in Groovy.

def s = """
END IF;

EXECUTE IMMEDIATE ' CREATE INDEX #idx1
      ON somename ( row_id,
                           something)';

   IF v_sys_error <> 0 THEN
      GOTO SQL_ERROR;

   END IF;
"""

def expect = """
EXECUTE IMMEDIATE ' CREATE INDEX #idx1
      ON somename ( row_id,
                           something)';
""".trim()

def exe = s =~ /(?ms)(EXECUTE.*?;)/

assert expect == exe[0][1]

answered Sep 01 '09 at 20:09

John Wagenleitner

10,967
1
40
39

1

Thanks. Using m & s together give the benefit of making the pattern span across muiltiple lines – Gaurav Khurana Jan 02 '19 at 06:48

score 8 · Answer 3 · answered Oct 03 '12 at 05:05

I had the same question and the other two answeres pointed me in the right direction. In this particular case, you want to be able to use patterns (and select groups) that span multiple lines, i.e. you want the dot to also match newline characters. Default behaviour does not match newlines. That is why you need to use the dotall (s) flag:

/(?s)(EXECUTE).*?;/

This is how you specify flags in groovy patterns.

For testing different patterns and flags I found RegExr quite useful.

The "mode modifier" feature is not supported in this flavor of RegEx. — coz, Aug 02 '23 at 13:15

regex over multiple lines in Groovy

3 Answers3

Linked