Google Sheets Regex for the inconsistent pattern
Attached are the Inputs and Expected Outputs based on which I wanted a common regex pattern which can be used in Google Sheets:
Example: In case of following string in a cell: "30m DEVO-67, DEVO-68 1h DEVO-69, DEVO-70 2h DEVO-75"
Following should be the output: DEVO-67, DEVO-68, DEVO-69, DEVO-70, DEVO-75
Basically wanted to extract all the DEVO followed by Dash and a number from any given string.
I tried following but it is not working:
=REGEXREPLACE(B1,"[0-9]+\S+\s+DEVO-(\d+).*","DEVO - $1")
Solution
=REGEXREPLACE(A2,"(?is).*?(DEVO-\d+)","$1, ")
The idea is to select batches of
"Any unwanted string""DEVO-number"
and replace with
"DEVO-number",
with case insensitive matching and single line mode: (?is)
- Regex to capture VBA comments
- Print the matched string using perl
- print the matched word in perl regex
- Perl Regex fails to compile looking for \object
- Replacing multiple blank lines with one blank line using RegEx search and replace
- regex for match all <img> tag and extract the "src" attribute
- REGEX to split address components using R - numbers in street/avenue names
- How to use \b word boundary in pandas str.contains?
- Detecting *all* emojis
- Why does my password regex fail to validate a specific string only which have paranthesis as special characters?
- Multibyte trim in PHP?
- RegEx finding pattern in string ie 128x128
- Regex - capture only if string exists, if not ignore
- match dates using python regular expressions
- Why is commenting out multiline comments in c++ inconsistent?
- How to split string with Regex.Split and keep all separators?
- Regex to match mentions that begin with @
- RegEx to allow anything except blanks or all spaces?
- Regular expression to match numbers, excluding those ending with a trailing comma or period
- Get words and quoted phrases from text as an array
- How to test if a string has Markdown in it
- Comma separated names list to parse into dictionary
- Regular expression to exclude 2 words
- MySQL query with regexp not working in Drupal
- Java Regex Give All String Except those within Single Quotes
- Sanitize and standardize a string that contains an indeterminate sequence of delimiting characters and whitespaces
- Concrete JavaScript regular expression for accented characters (diacritics)
- How to remove all line breaks from a string
- Regular expression to extract valid cell references from a spreadsheet formula
- How to remove word after ")." line by line?