CRM On Demand - Administration (MOSC)

MOSC Banner

Expression help --- Email domain name checking

edited Apr 17, 2012 5:11PM in CRM On Demand - Administration (MOSC) 1 commentAnswered
All,

I have a requirement to check various email domains and update a check box field if the email domain matches :

Eg:   firstname.lastname@yahoo.com

i am building an expression to check the domain and if they match then flag the field (checkbox field in my case).

I have written an expression like below :

Right([<Email_Address_ITAG>],Len([<Email_Address_ITAG>]) - InStr([<Email_Address_ITAG>],'@'))

this expression returns the value after the value '@' , I have multiple domains that has to be checked now and if they match the checkbox field needs to be updated .

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