Page 1 of 1
Handling Special Characters
Posted: Tue Feb 12, 2008 1:57 pm
by 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.
Re: Handling Special Characters
Posted: Tue Feb 12, 2008 2:02 pm
by chulett
just4u_sharath wrote:To my understanding trim can only wipe away spaces.
Not true.
Define 'special'.
Re: Handling Special Characters
Posted: Tue Feb 12, 2008 2:48 pm
by just4u_sharath
chulett wrote:just4u_sharath wrote: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
Posted: Tue Feb 12, 2008 3:13 pm
by chulett
What? No, I want you to define for us what specifically you mean by 'special' characters.
Posted: Tue Feb 12, 2008 3:58 pm
by 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.
Posted: Tue Feb 12, 2008 4:18 pm
by manishk
you can use convert function ..convert the special charater to spaces and tri off. Inorder to convert use the ascii table