I'm not sure I completely understand. Would you be able to post an example of the data and the desired outcome?
We have a field HomeEmail. I have to ensure that the data is clean and correct so I need to scan that field to ensure that they all have the @ symbol within the email. Because our database is so large, its easier to pull out HomeEmail that doesn't contain an @ symbol.
For example, I would want to find jocheaneyslm-ltd.co.uk as that would be an invalid email.
If I use the Wildcard Tab on the Filter option to say Does Not Contain @, it gives me anyone with a blank field too which I don't want.
Hope that makes sense.
I'm a DataManager, dealing with millions of records and accuracy of data is essential for us as it costs us money if emails and mobiles are not formatted correctly. Most of my work involves scanning and cleansing data.
Hi Jo, one way of doing this is to create two filters. The first one is the one you've got using the wildcard filter. For the second one you just need to test if the field is null like this:
Put that on the filter shelf, choose 'True' and exclude. That should get rid of all your nulls (blanks). Hope this works for you.
You're welcome Jo.