Handling Special Characters

[just4u_sharath]

How can i trim the special characters if i get them in my data. To my understanding trim can only wipe away spaces. Do we have any functions to trim the special characters in Parallel extender. Please let me know.

[chulett]

To my understanding trim can only wipe away spaces.

Not true.

Define 'special'.

[just4u_sharath]

To my understanding trim can only wipe away spaces.

Not true.

Define 'special'.

i looked for this in transformer (Define special). but i didnt find it. Please let me know where can i use this and its implementation

[chulett]

What? No, I want you to define for us what specifically you mean by 'special' characters.

[ray.wurlod]

It is sometimes necessary, with NLS enabled, to handle characters that are not ordinarily trimmable, such as the Japanese space character. You can write a routine but it is much easier to add the code point for this character to the TRIMMABLE class in the CTYPE category of the NLS locale.

[manishk]

you can use convert function ..convert the special charater to spaces and tri off. Inorder to convert use the ascii table