# | Date | Forum | Type | Thread | Post |
4 | 21 Aug 2012 @ 09:33 PDT | Database | Reply | Regular 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... |
3 | 19 Aug 2012 @ 10:04 PDT | Database | Topic | Regular 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:]... |
2 | 15 Aug 2012 @ 09:18 PDT | Database | Topic | Regular 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... |
1 | 10 Aug 2012 @ 08:14 PDT | Database | Topic | What 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... |
|
|