Trim any/all non-approved characters from a field.

This code will strip out all the specified characters from a single or multi-value field, while preserving the multiple values. Just enter the code below into your field InputTranslation event.
Lotus Formula

TrimChars := "`" : "~" : "!" : "@" : "#" : "$" : "%" : "^" : "&" : "*" : "(" : ")" : "_" : "+" : "-" : "=" : "[" : "]" : "\\" : "{" : "}" : "|" : ";" : "'" : "’" : ":" : "\"" : "<" : ">" : "?" : "." : "/";

@ReplaceSubstring(@ThisValue ; TrimChars ; "")

Posted by fbrefere001 on Thursday March 6, 2003