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

The MOD Function


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: August 13, 2020