Fixing Capitalization Errors

Ethan_Hutcheson
Level 1

Fixing Capitalization Errors

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?
Tags (1)
2 REPLIES 2
Josh_Hill13
Level 10 - Champion Alumni

Re: Fixing Capitalization Errors

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

Re: Fixing Capitalization Errors

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.