How can we find if a string should not start or end with special characters

[yasin_fazwani]

For eg. "Name" is valid; "1Name" is invalid; "Name?" is invalid. 

[Akshay1 · Accepted solution]

Hello yasin, in order to flag strings that start or end with a special character, we need to use a combination of the If statement and a regular expression.

if(regexp( @Name@   ,“.*[/[^A-Za-z]].*“, “true”) = “true”, “invalid”, “valid”) this regular expression should help you do that.