CRM On Demand - Administration (MOSC)

MOSC Banner

How to Restrict Input of Special Characters and Non-English Alphabets in Account Name field

edited Nov 24, 2018 4:09AM in CRM On Demand - Administration (MOSC) 5 commentsAnswered
Hi,

We have a Requirement that: In the Account Name field, Users should not be able to enter any characters / Non-English Alphabets / symbols other than English Alphabets, Numbers and only these characters: ;,.()"&

We used the following expression: 

(((FindOneOf([<AccountName>],"qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM")=1)  OR (FindOneOf([<AccountName>],"9876543210")=1) )AND  (FindOneOf([<AccountName>],"!@#$%^*")=0))

It does a strange thing: in the Account Name it Does Not Allow: 屁吾艾TEST but Allows Users to type: TEST屁吾艾

Is this a System Defect / limitation or we have a viable workaround.

Thanks and regards

SG

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center