#DateForumTypeThreadPost
421 Aug 2012 @ 09:33 PDTDatabaseReplyRegular Expression in Teradata Finally we arrived at the solution...by using the same function with parameters... select regexp_replace('BIVT 0 OK','[[:cntrl:]]','|',1,0,'i') It returns...
319 Aug 2012 @ 10:04 PDTDatabaseTopicRegular Expression in Teradata Hi All, Finally got some idea on Regular expressions with control characters in Teradata.. Sample:-(With One Control Character) select regexp_replace('BIVT 0','[[:cntrl:]...
215 Aug 2012 @ 09:18 PDTDatabaseTopicRegular Expression in Teradata Hi All, I have a requirement to find the control characters in a column's data and it should be replaced by a Character/Symbol using Regular Expression in Teradata..How to find cont...
110 Aug 2012 @ 08:14 PDTDatabaseTopicWhat is the Equivalent Function of TRUNC for Date in Teradata?? Hi All,   I have some idea of TRUNC for Date and Number in Oracle,but not in Teradata..How to use it in teradata...Can anyone explain....      TRUNC(Column_N...