Check for bad email address

Function ScriptedField
 Dim regEx, retVal
 dim res

 Set regEx = New RegExp
 res = "[{""email_address"":""@@ORG:email@@""}]"

 ' Create regular expression:
 regEx.Pattern ="^[\w-\.]{1,}\@([\da-zA-Z-]{1,}\.){1,}[\da-zA-Z-]{2,3}$" 

 ' Set pattern:
 regEx.IgnoreCase = true

 ' Set case sensitivity.
 If "@@ORG:email@@" <> "" Then
  retVal = regEx.Test("@@ORG:email@@")
  If retVal = False Then
   LogMessage "Error: Bad Email Address.  Email:@@ORG:email@@; SeedwareID:@@ORG:seedware_id@@; AccountName:@@ORG:account_name@@"
  End If 
 End If
 
 ScriptedField=res
End Function

• Related Articles

• Email (IMAP) Connector

  Additional Documentation This Connector is based on the Email ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/REG/ado/ Establishing a Connection ...

• Check for duplicates using xref

  I needed to check for duplicate attachments in a system and remove the duplicates. I created a Job that used the same origin and destination and pulled all records from the Attachments table. I had a before operation that would read and write to the ...

• SugarCRM REST Connector

    SugarCRM REST Origin Use JSONLint to validate JSON: https://jsonlint.com/. Sample Origin Filters See the GET /<module> filterList in the SugarCRM REST Help: https://SERVER/rest/v10/help/ Note the [{...}] surrounding the filter. This is required. ...

• Frequently Asked Questions

  What is Cloud migration? Cloud migration is the process of moving your data from one CRM system to another through an exclusively Cloud based platform instead of downloaded software on your computer. The Cloud migration wizard guides users through ...

• Exchange Connector

  Additional Documentation This Connector is based on the Microsoft Exchange ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/CEG/ado/ Overview The "Exchange (NEW)" connector ...