handling special characters

[venni]

Hi frnds,
I have small query...
I hav sorcu data like this..

a$a%d
b^f*g
g@j&*h

pls can any one tell me how to handle this special char's.

[swarnkar]

Hi frnds,
I have small query...
I hav sorcu data like this..

a$a%d
b^f*g
g@j&*h

pls can any one tell me how to handle this special char's.

You can use Oconv function with "MCA" or "MCP" options to get Alpha-Numeric or Printable characters.

[fareeda_b]

Hi ,
As of my knowledge u can use string function 2 remove special characters in Query

Select substr(columnname,2,len(columnname) from tablename;

try this it will help you to remove special characters in query

if u want to remove in DS use convert function

thanks
fareeda

[ray.wurlod]

Which of the characters is "special"?

Oconv() and Iconv() are not available in parallel jobs. Convert() is.

The way I would go about this is to set up a stage variable which is initialized to contain a list of all the special characters. In an output column derivation I would use something like

Code: Select all

Convert(svSpecialChars, "", InLink.SourceField)