searchByRegex property
True if the find value is a regex.
The regular expression and replacement should follow Java regex rules at
https://docs.oracle.com/javase/8/docs/api/java/util/regex/Pattern.html.
The replacement string is allowed to refer to capturing groups. For
example, if one cell has the contents "Google Sheets"
and another has
"Google Docs"
, then searching for "o.* (.*)"
with a replacement of
"$1 Rocks"
would change the contents of the cells to "GSheets Rocks"
and "GDocs Rocks"
respectively.
Implementation
core.bool? searchByRegex;