regexregex-lookaroundsre2
Does Google Sheets Regex engine support lookbehind?
I was under the impression that Sheets supports re2, which does not support lookaround.
Consider he following Sheet's example script. Regex expected to match the word dog either by itself or if preceded by the word cat.
function testRegex(){
var rg = /(?<=(cat|\b))dog/;
var s = "catdog";
Logger.log("%s: %s",s,rg.test(s));
s = "sdog";
Logger.log("%s: %s",s,rg.test(s));
s = "dog";
Logger.log("%s: %s",s,rg.test(s));
}
The results are perfect:
So question is supported or not?
Solution
You are using JavaScript in your Google Apps script. GAS now uses the modern JavaScript engine that supports lookbehinds, named capturing groups, s modifier. So, your pattern works well.
If you use a lookbehind pattern in a REGEXEXTRACT or REGEXREPLACE formula, it will fail as those REGEX~ functions use RE2 regex library. You can't use a lookbehind there.
- JS Regex MatchAll with combination of Comma & Semicolon
- Symfony Routing Host Regular Expression
- Regular Expression to parse Common Name from Distinguished Name
- Add a value and sum it up using Notepad++
- Regex for Number "05XXXXXXXX"
- Replace one character but not two in a string
- how to escape hyphen in regex character group in c
- Why do some regex engines match .* twice in a single input string?
- What do 'lazy' and 'greedy' mean in the context of regular expressions?
- How to test if a RegExp contains capturing groups in its definition?
- create regex to match format of 00:00:00 for duration (not time)
- regex for expression with one separator hyphen
- Remove special character and units form Pandas column name with Python
- Replace variables in a formula with their definitions
- RegEx to differentiate chemical compound names from pattern
- Replace letters inside words that start with and end with a specific letter not occurring anywhere else with the same amount of a specific character
- open vimeo url in colorbox using jQuery filter
- Split address and numbers
- Pyspark Regular Expression add double quotes after comma
- In the regex world what's a flavor and which flavor does Java use?
- Problems with table extraction using pdfplumber - empty fields in large tables
- How do I pass a variable into regex with Node js?
- How do I use regex in a SQLite query?
- Python RegEx: match words in a string only if they are not preceded by a specific character
- Regular expression that ignores HTML entities
- Allow access to page only from certain referrer
- Regex to match string containing two names in any order
- Matching boot times from log using sed -E
- Validate Bangladeshi phone number with optional +88 or 01 preceeding 11 digits
- Using setCustomValidity stops input from validating