Jump to content

Parsing for illegal characters


This topic is 6994 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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,

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

Validate using

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

or

Alias = Filter( Alias; "01234567890abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ" )

Link to comment
Share on other sites

This topic is 6994 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.