Replacing symbols from input column

Database
Enthusiast

Replacing symbols from input column

Hi,

From source I am getting values like '5 T', 'RT', 'S.*09', 'XV-4' etc. My requirement is to remove any space, '*', '-', '.' so that output should look like: '5T', 'RT', 'S09', 'XV4' . Is there any way I can do it in a single step?




1 REPLY
Senior Apprentice

Re: Replacing symbols from input column

Hi Moutusi,

what's your Teradata release?

oTranslate(col, ' *-.', '') removes those characters.