1 Reply Latest reply on Mar 20, 2015 12:11 PM by Jonathan Drummey

    Workaround for Regexp_instr function in Extract SQL

    Heather Roach

      I am pulling data (360K records) from Teradata 14.0 and using a Regexp_instr function to trim all numbers at the end of character string.  I get the following error: Tableau Data Engine Error: 4: ReadOnlyDataStream::Extend when refreshing the Extract.  I need help finding a SQL workaround to be used in Teradata and Tableau that will remove all digits at the end of a string.

       

      Current SQL:       substr(MEMO_MAN_TXT, 0, REGEXP_INSTR(MEMO_MAN_TXT, '[[:digit:]]{9}'))