regex over multiple lines in Groovy

regex groovy multiline
Omnipresent picture Omnipresent · Sep 1, 2009 · Viewed 23.1k times · Source

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).*;

Answer

Nosrama picture Nosrama · Sep 1, 2009

(?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).*?;/

Related questions

extract substring using regex in groovy

If I have the following pattern in some text: def articleContent = "<![CDATA[ Hellow World ]]>" I would like to extract the "Hellow World" part, so I use the following code to match it: def contentRegex = "<![CDATA[ /(.)*/ ]]>" def …

Read More
Grails: Splitting a string that contains a pipe

I’m trying to split a String. Simple examples work: groovy:000> print "abc,def".split(","); [abc, def]===> null groovy:000> But instead of a comma, I need to split it on pipes, and I’m not getting the …

Read More
Replace all occurrences in a String by using regex in groovy

When there are only one occurrence my code works: def result = "Text 1,1" def matches = (result =~ /^.+\s([0-9],[0-9])$/ ).with { m -> m.matches() ? result.replace(/${m[ 0 ][ 1 ]}/, 'X'+m[ 0 ][ 1 ]+'X') : result } assert "Text X,X" == matches How can I do …

Read More