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)
- How can I make these html & php patterns work?
- Replace backslash '\' with forward '/' slash in VS Code snippets with Regex
- Python regular expression for multiple split criteria
- Using regular expression to extract substring
- Regex to find a float
- Regex replace with a small text change?
- Regex for one or more words separated by spaces
- How does Python's unittest library match patterns passed via the -p parameter?
- What regex can allow a delimiter, but only if the surrounding groups exist?
- Apache Nifi Expression Language: find part of content, which matches to regex
- Using a gsub to split a name based on special characters
- Extracting only characters from a string in Python
- RegEx for word boundary but still match if is preceded or followed by special chars
- Analogue for regex '?' (preceding item optional) in T-SQL like?
- Private IP Address Identifier in Regular Expression
- Whitespace woes in Regex
- Visual Basic .net Regex match does not work - despite working on a testing tool?
- Extracting with regex two conditions of some text
- Google Sheets Regex for the inconsistent pattern
- String Expansion program gives incorrect output
- regex to remove ordinals
- Using gsub to extract all information before and after the first white space
- How to replace all BUT the first occurrence of a pattern in string
- How to solve JS Regex not working during keypress
- Match whitespace but not newlines
- Regex - Match repeated character not in sequence
- Regular expressions: Matching strings with dot (.)?
- How to deal with Polish Characters while using regex?
- ADF - Dataflow expression builder cleaning/parsing columns
- Can I test if a regex is valid in C# without throwing exception