regexgoogle-sheetsgoogle-sheets-formularepeatre2
Regular expression that matches a pattern as well as any number of comma space separated repetitions
What regular expression matches the below
- a pattern that's composed of two letters and numbers
- any comma-space repetitions of said pattern
Assume the below cells, their contents and the times the pattern is repeated
| Cell | Content | Repetitions |
|---|---|---|
| A1 | CC148 | 0 |
| A2 | CC249, CC193 | 1 |
| A3 | CC345, CC856, CC749 | 2 |
For simplicity, I will refer to the regular expression I need as myRegEx
| Content | Formula | Expected Output |
|---|---|---|
| CC148 | REGEXMATCH(A1, myRegEx) | TRUE |
| CC249, CC193 | REGEXMATCH(A2, myRegEx) | TRUE |
| CC345, CC856, CC749 | REGEXMATCH(A3, myRegEx) | TRUE |
The below expressions for each respective cell would return true, but the problem is that I'm after one expression that gets the job done, independently of the number of repetitions.
CC\d+CC\d+, CC\d+CC\d+, CC\d+, CC\d+
The below expression didn't bring the desired outcome
(CC\d+)|.
Solution
try:
=INDEX(REGEXMATCH(" "&A1:A10&",", REPT(" CC\d+,",
LEN(REGEXREPLACE(A1:A10, "[^,]", ))+1)))
- Regular expression to return text between parenthesis
- Find procedure name in all other procedures
- How to use posix regexp operator for substring match
- regex for checking URL's wildcard for both subdomain and top level domain?
- Replace (~) with Double Quote (") in C#
- Steps to draw a DFA (or NFA) from a simple statement?
- Elegant regular expression to match all punctuations but not "'" in emacs Lisp?
- Matlab split string multiple delimiters
- Split on regex (more than a character, maybe variable width) and keep the separator like GNU awk
- How to use regexp to perform a glob in C/C++ (Linux)
- Regexp matching a string - positive lookahead
- Extract values from string using regex
- Does the Python regular expression module use BRE or ERE?
- Split string on punctuation symbols without losing the symbols
- Wrapping subpattern in square braces does not encapsulate the match as expected in regular expression
- preg_replace regular expression HTML
- Split a string by more than one delimiter
- Split string on last occurrence of an underscore
- Split string on an optional space between a punctuation mark and a letter
- Perl search and replace words in file
- Match RegEx except where preceded by character
- Substitute substring with multiple characters
- grep REGEX parse html for email
- RegEx: How can I match all numbers greater than 49?
- Find root of path
- Efficient way in using lookarounds for regex split
- Parse datetime string into an array of its individual units
- Using Regex to parse out style command line parameters starting with - or -- with options
- How to remove the first and last slash
- Why does running the same regex twice yield different results?