Fixing Capitalization Errors | Community
Skip to main content
Ethan_Hutcheson
Level 2
April 9, 2014
Question

Fixing Capitalization Errors

  • April 9, 2014
  • 2 replies
  • 1282 views
Is there a way to automate updating first and last name values so that they have initial capitals rather than all upper or all lower case?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Josh_Hill13
Level 10
April 9, 2014
You may be able to do this with something like Demand Tools or an intern ;)

This cannot be done in Marketo.
Matt_Stone2
Level 9
April 9, 2014
If you really wanted to get creative, you could do this with the API. You could have a script that runs on a cron schedule (say, daily) and looks at all the new leads for that day. It could take all of their names, lowercase them, then just capitalize the first letters, and then update the record.

You'd have to build in some logic if you really wanted to make it work well, so that you're not screwing up names that are formatted fine and don't follow the very basic rule I outlined above.

All in all, this is probably not worth the effort, but it might be fun to try.