Page 1 of 1
UnwantedCharecters remove which are not identified bykeyboad
Posted: Thu Apr 17, 2008 4:21 am
by basu.ds
Hi all,
Can any one help me on this i want to remove the charecters which are not identified by the keyboard like special symbols any routine needs to write or any fredefined function is there?if i want to convert a string or charecter to ascii value what could be the NLS ?
Thanks in advance
basu
Posted: Thu Apr 17, 2008 4:35 am
by ray.wurlod
Oconv(InLink.TheString, "MCP") will convert all non-printable characters to ".".
Posted: Thu Apr 17, 2008 4:39 am
by basu.ds
Thaks a lot ray but i don't want period symbol also
Posted: Thu Apr 17, 2008 5:37 am
by ray.wurlod
Code: Select all
Convert(".", "", Oconv(InLink.TheString, "MCP"))
Posted: Thu Apr 17, 2008 6:40 am
by chulett
As long as you realize that will remove all periods, including ones not generated from the MCP conversion.
Posted: Fri Apr 18, 2008 12:17 am
by basu.ds
thanks a lot for responds.all periods will convert so if period is already there in my source data that should be as it is.in this case how can i handle .let me if anything can be done.
thnaks
Posted: Fri Apr 18, 2008 12:25 am
by ray.wurlod
Change your "real" dot to something else, such as ~; effect the removal, then convert all tilde characters back to dots.
Posted: Fri Apr 18, 2008 2:53 am
by basu.ds
Thanks a lot ray for you are guidence.i got it but i ask for better than this any have i will fallow this only