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.
Convert asci characters in string to blank
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.