regexgoogle-sheetsgoogle-sheets-formulaescapingre2
How to ignore parenthesis in a REGEXMATCH?
I am attempting to sum up values based on matching a substring. The issue I am running into is that the substring and string both have parenthesis and therefore the match is failing.
I have created a sample sheet to show the basics of what is going on.
A little more context, the idea is to sum up all the projects that have the same start but can have different - allocations.
Any help making E2 correctly find the 3 Innovation Lap (TEST) Projects but not the 1 Test Innovation Lab (TEST) Projects.
I tried a SUMIF but it did not allow the level of detail I wanted.
Solution
you need to escape them with backslash \
=REGEXMATCH(B21; "te\(\)st")
injected into the 2nd argument, it would be:
=REGEXMATCH(B21; REGEXREPLACE(C21; "(\(.+)(\))"; "\\$1\\$2"))
- Validate user input string only contains letters, numbers, and underscores
- How escape characters in a variable to be used in a regex pattern?
- How to make preg_match() match more than once?
- Use grep to match a pattern in a line only once
- Validate that a string contains only space-delimited alphanumeric words which do not start with a digit
- Match parenthetical expressions in a string
- Regex matching "|" separated values for Union types
- Regex for whitespace delimiter except for [ and ] characters
- Matching a fixed position in a string using C++ regex
- Get video id from the url path of an <iframe>'s src value
- What is proper RegEx expression for SWIFT codes?
- Java regular expression for multiple matchers
- Get the number from inside of online javascript function call within an HTML element
- How to Bookmark Normal and Decimal Percentage Numbers in Notepad++?
- How to convert oracle regex pattern into Databricks compatible version?
- avoiding interference between slugs and controller or plugin names in cakephp 2.x router
- How to parse and capture any measurement unit
- Validate a potentially multibyte string to have a minimum length and contain only whitelisted characters
- Validate if a string is alphanumeric
- Get all integers which follow certain symbols in a string with multiple delimiters
- How to regex compare a string in dash?
- How to match regexp with ash?
- Extract float/double value
- How to write a Regex that targets the first match in each line only?
- Regex any ASCII character
- How to match {0} but allowing proper escape?
- Php put a space in front of capitals in a string (Regex)
- Get the leading float value from a string
- Find everything between two XML tags with RegEx
- Extract mileage value from an eBay webpages