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. ...

• Starfish ETL Scheduler

  Installation The Scheduler is a run as Windows Service. It may installed on any server which has access to the web service, but for the sake of simplicity it is recommended to be installed the same server as the Starfish Engine. The Scheduler reads ...

• 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 ...