match multiline strings with regex

Question

Is it possible to match multiline strings with match() function? I tried to apply match(/(abc)\rdef/) to a cell containing 2 lines of text abc & def, but it does not work. Is there a way to get "abc" as result?

From the link below, it should work with \n instead of \r !? Actually with a find() instead of a match()...
https://stackoverflow.com/questions/50758805/text-with-n-matching-in-regex-and-openrefine/50759334#50759334 — B. Go, Jan 31 '19 at 00:37

Ettore Rizza · Accepted Answer · 2019-01-31T08:14:59.510

0

Simply use \n (newline) instead of \r (carriage return).

value.match(/(abc)\ndef/)

But you have to indicate where the newline is. match has no "multliline" parameter, so the dot (.) doesn't match line breaks.

edited Jan 31 '19 at 08:14

answered Jan 31 '19 at 08:09

Ettore Rizza

2,800
2
11
23

score 0 · Answer 2 · answered Jan 31 '19 at 21:22

0

Of course ! Thanx Ettore

And I found a way to do what I wanted with value.match(/(.*?\n)*(def)\n?(.*?\n?)*/)

answered Jan 31 '19 at 21:22

Mathieu Saby

125
5

match multiline strings with regex

2 Answers2