validation to prevent special characters and spaces and allow only alphanumeric character.

Question

Hey Community,

As a beginner, need a small favor from your end.

Using a custom Validation Rule:

How to prevent special characters and spaces in a field and allow only alphanumeric characters such that it does not affect any old records.

Best Regards,

Swetha

Narender Singh · Accepted Answer

Create a VR like this:     NOT(REGEX( FIELD NAME,"^[a-zA-Z0-9]*$")))

Omkar Sai · Answer

what happens in the case to avoid double quotes "".

Data Management