To remove special characters from a string

Database
rvk
N/A

To remove special characters from a string

Hi All,

As a part of validating a requirement I need to remove special characters from a string .so could you please suggest any function to remove special characters from a string or to replace the special characters in a string with blanks?

For ex

INPUT                                   OUTPUT              

VBN MGH & CO                VBN MGH CO

There are two functions oreplace and regexp_replace which does the above requirement . But both of these functions are not supported in Teradata v.13.

Kindly help me in solving this issue

1 REPLY
Enthusiast

Re: To remove special characters from a string

Hi,

if still on td 13, then position alongwith substr function can be used. position to identify position of special character in string and substr to dissect and concatanate strings.