Hello, I am using APEX 22.1 and in need of help in building a regular expression for an item validation. I need a validation that only allows users to have letters/numbers/dashes/underscores/periods/spaces in the item text field.
My first attempt at this was to create a validation of type Regular Expression with this expression: ^[a-zA-Z0-9\._\-\s]+$
However, when I test this, the validation does not work correctly. I have a handful of records that need to be updated as they have (). I can update the one without error, but when I try and update other records to fit the validation, I still get an error.
Does anyone have suggestions on how to proceed? Is it an issue with my regex or something else?