Program for correcting ' in name | Community
Skip to main content
Brian_Whipple
Brian_Whipple
Level 2
December 5, 2018
Question

Program for correcting ' in name

  • December 5, 2018
  • 1 reply
  • 1166 views

Hello,

In the process of importing some contacts into our database, I noticed that names with an apostrophe were imported as ' by mistake. 

Example: O'Donnell was imported as O'Donnell

Is there an operational program and smart campaign that can run in the background that corrects this on an ongoing basis? Or is the only solution to improve my processes before we import?

Thanks,

Brian

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

1 reply

Devraj_Grewal
Devraj_Grewal
Level 10
December 5, 2018

Brian,

For the future, yes, I would urge you to fix the processes so you don't make that error during import. As for fixing those records, you should run a smart list of those that have the error and include the email address as a column. Export this smart list into Excel, fix the data and re-import into Marketo. If you are finding the issue is with Marketo importing, you can use the SFDC Data Loader if that is your native CRM.

Terms & ConditionsAccessibility statement

Loading footer...