1 Reply Latest reply on Jun 6, 2018 11:10 AM by John Hopkins

    REGEXP_REPLACE: #Error message with data on Tableau Server?

    John Hopkins

      I'm trying to apply a REGEXP_REPLACE function against a field from a Tableau Server hosted data source (an extract from MySQL).

       

      Version: 10.4.6

       

      Hard-coding the input works:  REGEXP_EXTRACT('Accepted Applicants with Potential for Honors Program WHNR103','([W][A-Z]{2,3})')      WHNR is the result

       

      Referencing a field from the Tableau Server data source returns "#Error":  REGEXP_EXTRACT([Specification Name],'([W][A-Z]{2,3})')

       

      Sounds similar to this issue.

      Doing a TRIM on a field - Get a #Error

       

      Is this a known problem?

      -John