Normalize first name token

Forum|Forum|11 years ago
October 2, 2014
4 replies
2502 views

Hi,

We would like to insert first name token in our email subject line. However, some of our first names in our database are in all caps and some of them are in all lower cases. Is there any functionality in Marketo that enables only capitalize the first letter of the first name for all contacts in the smart list?

Thanks!
Jeanine

Marketo

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

Best answer by

I don't think so, but you can easily export your entire Marketo database out into Excel (with columns FIRST NAME and EMAIL only unless you need the others) and do the same in Excel, simply re-uploading the list back with the changes.

A

Anonymous

Accepted solution

I don't think so, but you can easily export your entire Marketo database out into Excel (with columns FIRST NAME and EMAIL only unless you need the others) and do the same in Excel, simply re-uploading the list back with the changes.

A

Anonymous

Here's a link on how to do that in Excel: http://office.microsoft.com/en-us/excel-help/use-formulas-to-edit-correct-and-proofread-text-RZ006183133.aspx?section=3

A

Anonymous

We have a feature called Email Scripting that will allow you to control this. There is more information here about Velocity Scripting. I cannot tell you how to write the code, but I do know it's possible.

A

Anonymous

Thanks for the replies!

Jeanine

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded