Page 1 of 1

Convert asci characters in string to blank

Posted: Wed Jun 22, 2011 1:22 pm
by koojo
I need to convert a character string with any special characters in them.

Something like the convert function but want to use a ascii range to schan the characters and remove them.

I need to scan all special characters (Hex code - 0 to 1F) and remove them. Can I do this with a single function.

Posted: Wed Jun 22, 2011 2:46 pm
by jwiles
An embedded convert() within a convert() will do this...several examples of doing just what you have asked for are in the forum for the searching...

Regards,

Posted: Wed Jun 22, 2011 4:46 pm
by ray.wurlod
Don't refer to these characters as "special" - they're not. If you must, refer to them as Control Set 0. Initialize a stage variable to contain a concatenated string of all 32 (specified using the Char() function) and use Convert() in the derivation expressions to convert this string of characters to "" or " ", depending on what you mean by "blank".