Archives of the TeradataForum
Message Posted: Thu, 08 Jan 2004 @ 11:57:23 GMT
You might want to do that kind of cleansing outside of TD, especially if the volumes are high like in CDRs. If you really are restricted to the database then one of the recent threads might be useful:
If the URL does not work, search for the thread entitled "Extracting characters from a string" in the Dec 2003 archive. The thread discusses a more generic case.
Yet another, and very new, way of doing this in TD would be to write your own UDF (User Defined Function) but I cannot recommend them because I still have to get my hands on them and gain more experience.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|