regexgoogle-sheetsextractgoogle-sheets-formulaarray-formulas
Extract digits from string - Google spreadsheet
In Google spreadsheets, I need a formula to extract all digits (0 to 9) contained into an arbitrary string, that might contain any possible character and put them into a single cell.
Examples (Input -> Output)
d32Ελληνικάfe9j.r/3-fF66 -> 329366
h01j2j3jFxF$$4j5j6j7j8j9 -> 0123456789
Solution
You may replace all non-digit characters using the \D+ regex and an empty string replacement with
=REGEXREPLACE(A11,"\D+", "")
or with casting it to a number:
=VALUE(REGEXREPLACE(A11,"\D+", ""))
- Regex to match email addresses, and common obfuscations
- Regex to substitute the next two words after a matching point
- Regular expression isn't matching all hyperlinks in a string
- How to scrape iframe content using cURL
- How to use a regular expression in a jQuery selector?
- How to getElementByName() with a regex?
- Regular expressions with O(N) and backreferences support
- Split a string by commas which are not inside potentially nested parentheses
- Split a string on commas which are followed by a space, word, then a colon
- How to not match (negative match) certain patterns in lookbehind
- Notepad++ and regex: how to UPPERCASE specific part of a string / find / replace
- Remove duplicated words from a space delimited string
- How to understand the star quantifier (*) output
- shell script: search and replace over multiple lines
- Regex pattern to replace any occurrence of {...} with actual values
- Split string on dots unless the dot is inside double quotes
- Get all alphanumeric words with length of either 4 or 12 characters
- Replace the trailing digits of a URI with corresponding slug text
- Wrap <b> tags around substrings matching a regular expression
- Match urls with a specific signature
- Get words delimited by "#$"
- 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
- Match a patern with multiple entries in arbitrary order in Python with re
- 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