Is there an elegant way to check for 'illegal' characters, according to a schema that you define?

For example - users are allowed to create an on-screen alias for themselves, but you don't want their alias to contain any characters like:

!@#$%^&*()_+-=:;"',./<>

etc.

How can you perform validation on a text field to make sure that it doesn't contain characters you don't want?

Thanks,

Hi -

You could use an auto enter calc (with the do not replace existing value for field (if any)) checkbox unchecked and then filter to only contain information you want

Let ( Alias=Filter ( Alias; "01234567890abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"); Alias)

Yes, I know about this approach; is it possible to generate an error message regarding the 'bad' characters, without actually altering the field contents?

Validate using

Alias = Substitute( Alias; ["!"; ""]; ["@"; ""]; ["$"; ""]; ["%"; ""]; ["^"; ""]; ["&"; ""]; ["*"; ""]; ["("; ""]; [")"; ""]; ["_"; ""]; ["+"; ""]; ["-"; ""]; ["="; ""]; [":"; ""]; [";"; ""]; ["""; ""]; ["'"; ""]; [","; ""]; ["."; ""]; ["/"; ""]; ["<"; ""]; [">"; ""] )

or

Alias = Filter( Alias; "01234567890abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ" )

And if you want to calculate the bad characters that are being removed,

BadChar = Filter( Alias; "!@#$%^&*()_+-=:;"',./<>" )