Hi, calling on all REGEX experts for some help. Im needing assistance with a REGEX validation to allow only specific list of special characters.

Question

I want to allow these special characters: & ' * @ \ | ^ : , $ = ! / ` > - { ( [ < # % . + ? " } ) ] ; ~ _ and a blank space

Here is the validation I have but still getting Syntax error:

NOT(REGEX( Field Name ,"^[a-z A-Z&'*@\|^:,=!/`>{([<#%.+?"})]; ~_-]$")))

#REGEX #Validation Rule #Data Management

Himanshu Hunge · Accepted Answer

Hi @ Charles Porch III       REGEX are sometimes very clunky but it does work very well if it comes to validation. For example, in your case, every character has its own functionality but if we want to pass through that special character we need to pass with \ backslash.     Try to use this:   NOT(REGEX(Field Name ,"^[a-zA-Z&'*@|^:,;~_\-=!\/`>{}()<#%.+?"]$"))   Note:  You may use character class “[^\w]” but again in your case you want to consider only specific characters to pass through.   Thanks.

Charles Porch III · Answer

Thank you  @Himanshu Hunge https://trailblazers.salesforce.com/profileView?u=0053A00000Dr3ErQAJ  this validation worked perfectly for me.

Hi, calling on all REGEX experts for some help. Im needing assistance with a REGEX validation to allow only specific list of special characters.

REGEX

Risorse di formazione correlate

Ulteriore assistenza