Exercise: commentary

Now let's consider some of the specifics in detail from the preceding exercise, extracting data in the following code block:

REGEXP_EXTRACT([String of Data],'()') 
  • The expression pattern is purposely excluded here as it will be covered in detail later. The '()' code acts as a placeholder for the expression pattern.
  • The REGEXP_EXTRACT function used in this example is described in the help documentation:
Returns a substring of the given string that matches the capturing group within the regular expression pattern.
  • Note that as of this writing, the Tableau documentation does not communicate how to ensure that the pattern input section of the function is properly delimited. For this example, be sure to include '()' around ...

Get Mastering Tableau 2019.1 - Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.