Convert asci characters in string to blank

koojo · Post by **koojo** » Wed Jun 22, 2011 1:22 pm

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.

jwiles · Post by **jwiles** » Wed Jun 22, 2011 2:46 pm

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,

ray.wurlod · Post by **ray.wurlod** » Wed Jun 22, 2011 4:46 pm

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".