This page is for tips and tricks that have been helpful to users. If you have any suggestions please submit them via the Third Wave portal.

If the Bizweaver email tool is configured to send an email from a data field that contains email addresses and if a invalid email address is passed, the workflow can stop with errors. The following SQL statement examples can help find bad emails in the data on the SAP Contact Persons Table (OCPR).

Below is to check if the email is not properly formatted, this will not return any emails that are incorrect.

SELECT E_MailL
FROM OCPR
WHERE (E_MailL NOT LIKE '%_@__%.__%'
    OR PATINDEX('%[^a-z,0-9,@,.,_]%', REPLACE(E_MailL, '-', 'a')) <> 0)
    AND isnull(E_MailL,'')<>''

The following version only returns good emails.

SELECT E_MailL
FROM OCPR
WHERE (E_MailL LIKE '%_@__%.__%'
    AND PATINDEX('%[^a-z,0-9,@,.,_]%', REPLACE(E_MailL, '-', 'a')) = 0)
    AND isnull(E_MailL,'')<>''