Parsing for illegal characters

[AJB_UMASS]

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:

[email protected]#$%^&*()_+-=:;"',./<>

etc.

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

Thanks,

[andygaunt]

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)

[AJB_UMASS]

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

[-Queue-]

Validate using

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

or

Alias = Filter( Alias; "01234567890abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ" )

[QuinTech]

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

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