regexlooker-studiore2
How I extract number from text in Google Data Studio?
I tried this but it's still showing null as you can see in the screen. Please help to solve this.
REGEXP_EXTRACT(X,"[0-9]*[0-9]")
Solution
It can be achieved using the Calculated Field below which uses the REGEXP_EXTRACT function to extract the numbers and the CAST function to ensure that it's a Number field:
CAST(REGEXP_EXTRACT(Attività, "(\\d+)") AS NUMBER )
Google Data Studio Report and GIF to elaborate:
- 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?