I have a problem when I want to delete incorrect email addresses from lead records.
After we did a mass email using salesforce we found out that a lot of the email's are incorrect. In-order to delete these email addresses we have to import blank fields.
But SalesForce does not let you import blank fields. If you import a blank field, the field will not be updated and it will stay at it's old version.
This applies to the built in import wizard and also to the data loader(update/upsert options).
Any help will be greatly appreciated.