I have a table with a column of alpha-numeric data the currently has multiple (periods) "." and spaces in the string.
I need to remove them for data compare in another DBMS.
I have searched not only through this forum but others as well and can not seem to find the solution.
Note: orereplace is not an option as it is not installed and have no way to get it installed.
Here are a few examples of how the data is currently formated:
The periods are not always in the same place so any counting method will not work.
Thanks for taking the time to look.
UDFs will do this most efficient but
might outline an way how to do it the hard way.
Der Beginn aller Wissenschaften ist das Erstaunen, dass die Dinge sind, wie sie sind.-Aristoteles
Thanks ulrich - I saw that you had replyed to a previous post of mine on this issue. I will try this method and respond back soon.
Thanks again for looking.
Please download the UDF from below link and just install two UDF under replace folder.
There is two UDF oreplace1 and oreplace2 using which we have accomplish the same function. Please install the both UDF under syslib database in teradata and it works fine.