Page 1 of 1
handling special characters
Posted: Wed Nov 12, 2008 4:47 am
by 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.
Re: handling special characters
Posted: Wed Nov 12, 2008 4:49 am
by swarnkar
venni wrote: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.
hi
Posted: Wed Nov 12, 2008 6:10 am
by 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
Posted: Wed Nov 12, 2008 6:21 am
by 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)