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?