regexlooker-studiore2
How can I extract only numbers from a string using Google Data Studio RegEx?
I am trying to extract only the numbers from a string; for example:
+36,145
Expected result:
36145
Solution
For Chart-level fields, adding the CAST function and setting the field AS NUMBER ensures that it can be aggregated as required, when set as a metric (REGEXP_REPLACE defaults to a TEXT field):
CAST(REGEXP_REPLACE(X, "(\\+|,)", "") AS NUMBER )
Google Data Studio Report and GIF to elaborate:
- Elegant regular expression to match all punctuations but not "'" in emacs Lisp?
- Replace (~) with Double Quote (") in C#
- 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?
- Regex pattern to allow any ASCII chars. But not leading white spaces
- Split string on a space before one of two whitelisted words
- Regex to convert a string form to another
- Regex / Ruby - split keeping delimiter
- How do you state a regex pattern in Haskell?