Two functions, used together, can convert non-alpha characters to blanks, then remove the blanks from the string.
Given a field called X that has a value of - "[email protected]#d$e" - first use TRANSLATE to replace the non-alpha characters with blanks like so:
TRANSLATE(X," ","[email protected]#$")
This results in - "a b c d e
".
The second function - STRIPX - is used to remove multiple occurrences of a character from a string. In this case, the blanks created by the TRANSLATE function are removed. Add STRIPX to the calculation above to achieve the final result of "abcde
":
STRIPX(TRANSLATE(X," ","[email protected]#$")," ")
See Also:
Create a Sequence Number in Your View Results
Still have questions? We can help. Submit a case to Technical Support.