Start a new topic

RegEx to blank field if it contains specific phrase

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.

Hi Rachel,

It looks like your screen shot didn't come through. Did you check "Use Regular Expressions"?

image





Thank you,
Amanda
Omatic Software

Yes, I have that checked my dictionary looks exactly the same as yours as far as I can see. I even tried to create a new one and it still is not deleting the content. Here, I got the screen shot to work.

image


Try double clicking on the ".*@offline\.donordrive\.com", is there an extra space at the end?
Yup, that was it. It's always something simple. Thank you so much for your help.
Login or Signup to post a comment