How do I get rid of special characters after they are in Marketo?

Forum|Forum|10 years ago
January 20, 2016
2 replies
4476 views

Someone imported a list where every field separator seems to have turned into a special character. It displays as a diamond with a question mark in it.

These special characters are preventing the leads from syncing to Salesforce because the email address is invalid.

Can someone recommend a way to get rid of these characters from these leads?

Thanks!

Marketo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Grégoire_Miche2

Level 10

Hi Sharon,

Redo the import, checking that the source file is converted to UTF-8 encoding before doing it. It will update the fields with correct values.

-Greg

Grégoire_Miche2

Level 10

Second thoughts :

if some email addresses have a wrong character, it would be meaning they already had an extended character such as ç, è, ï or any other in the import file, so they would be invalid anyway. Check the import file on this.
If the emails were wrong in the first import, then reimporting corrected emails will not correct the bad data, it will create new leads, as email addresses will be different. In this case, it means you will have to delete the leads from the previous import and reimport them again.

-Greg

Abaran

Level 5

Hi Gregoire

It was nice to meeting you in Vegas. Sorry we did not get a chance to talk much.

Can you provide some more details on how you fix those issues? When I upload a list in Marketo, I first open it in notepad then save it in UTF-8 encoding. However, email addresses with extended characters keep those in. Does it mean they will be see as invalid? is there a tool to change the extended character to the proper one so upload in Marketo?

If not, what do you do to ensure you never have invalid characters before loading data into Marketo?

Thanks

Axel

A

Anonymous

Thanks to you both. I'll give it a try

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded