I am looking for a regular expression to delete the entire contents of a field if it contains a specific phrase. I am using this to delete emails containing "offline.donordrive.com" as DD automatically adds these email to constituents you enter as offline but we do not want them in our RE database. Any help would be appreciated.

Hi Rachel,

If the value is always offline.donordrive.com you can create a dictionary to replace that value with -BLANK- without needing regex.  To add -BLANK- as a replacement value, simply leave the replacement value field empty and click the + button.  

 

Sue

 

The field is will contain a full email address, example rachel@offline.donordrive.com. I need to know how to delete the full email using the criteria of contains "offline.donordrive.com" since the name before the @ will be different for each constituent. I can only seem to get it to delete the offline.donordrive.com, not everything else as well.

Rachel,

For your replacement value you would leave it blank and for your value to match on you would use .*@offline\.donordrive\.com

Turn on regular expressions for the blank row.

I just tried that but it isn't working. When I go to test it with the value of rachel@offline.donordrive.com it has an output of the same email. Any idea?

Rachel,

Could you post a screenshot of what you have? It worked correctly for me.

Here is the screenshot. Thank you for your help.

Yup, that was it. It's always something simple. Thank you so much for your help.