Forbid or Remove/Replace Specific Characters


#1

We require the ability to forbid certain characters from being entered into certain fields. That, or we need to auto-remove/replace said characters upon form-submission.

We are generating file- and path-names using formulas and must exclude characters that pose liability within certain network/server environments.

The exclusion list must be customizable; but to give you a sense of the baseline:

" ’ ` ~ ! ? ; : @ # $ % ^ & * ( ) [ ] { } \ | / > < , . - Ø, etc.


#2

AKA, is there a SUBSTITUTE( ) wrapper that I can use to remove/replace a long string of forbidden characters?