2 Replies Latest reply on Oct 14, 2016 1:47 PM by Prachi Naik

    Fetch a URL link from a string column using Regex_extract function

    Prachi Naik

      I am trying to fetch URL link from a text column called "Details" using reqex_extract function in tableau, but facing an error when I try the below expression in my calculated field.

       

      Details column data  - "2016 Jul 18 XYZ:  project name -- data fetch on 2016 Jul 18 -- https://docs.google.com/spreadsheets/123456789hdgvj"

      To fetch URL link- https://docs.google.com/spreadsheets/123456789hdgvj

       

      Calculated field(details_link)

      REGEXP_EXTRACT([Details],'(http|https)://([\w_-]+(?:(?:\.[\w_-]+)+))([\w.,@?^=%&:/~+#-]*[\w@?^=%&/~+#-])?

       

      error message

      • The Google BigQuery service was unable to compile the query.
      • Exactly one capturing group must be specified.

       

      Does Tableau support the use of regex when connected to bigquery?Can we extract links pointing to google docs or google drive?

       

      Any suggestions would be appreciated.

       

      Thanks

      Prachi