find and replace

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I would like to replace the information in a field of a group of contacts.
i.e. change the words in the title field to reflect a change in my industry, from Art Buyer to Art Producer, but can't seem to figure our how to do this.

I am using Firefox 53.0 on a Mac OS 10.9
Photo of David Arky Photography

David Arky Photography

  • 6 Posts
  • 0 Reply Likes

Posted 2 years ago

  • 0
  • 1
Photo of Josué F. Machado

Josué F. Machado, Champion

  • 76 Posts
  • 49 Reply Likes
David, I am assuming that you are talking about updating the data and not the name of the field. If so, here's how I would do it. I would export the contacts that you need to change and download the file. Using the downloaded data, I would create a new spreadsheet or CSV file with 2 fields: the email address and the field you need to be changed. Once you've made the changes and are happy with it, I'd use the file to upload the data back into Emma so that the field data can be updated. I hope this helps.
Photo of Ross Cochran

Ross Cochran, Official Rep

  • 134 Posts
  • 10 Reply Likes
Hi David,

Josué nailed this one. There isn't a way to do find and replace with Emma, but you can do this in Excel or your favorite spreadsheet program. The first step is to export your audience. Here are instructions on how to do that:

https://support.e2ma.net/Resource_Center/Account_how-to/exporting-your-audience

Next, use your spreadsheet program to find and replace the relevant fields.

After you've updated your fields, you can upload your corrected spreadsheet. Just make sure you select "add and update" to have the new data come through in your contact records. You can find information on how to do that upload here:

https://support.e2ma.net/Resource_Center/Account_how-to/importing-audience-members

Let us know if we can help with anything else!

Cheers!