Importing using email as matching field

Discussion created by keychange on Sep 30, 2014
Latest reply on Oct 6, 2014 by BruceRobertson

I can't believe I haven't encountered this in the past. But I am trying to update my database to remove bounced emails.


So I import from csv or xls format where I am using the email address as the matching field. However the processs finds no matching fields despite all of the email addresses being valid records. I realise this has to do with the '@' in the middle of the string but I can't come up with a process that will allow me to overcome the issue. I have around 700 records to update


Any suggestions please.