All Forums Database
Moutusi 38 posts Joined 03/13
08 May 2015
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?

 

Thanks, Moutusi
dnoeth 4628 posts Joined 11/04
09 May 2015

Hi Moutusi,
what's your Teradata release?
oTranslate(col, ' *-.', '') removes those characters.

Dieter

You must sign in to leave a comment.