Have you ever gotten an email addressed to jane doe, (all lower case), or JANE DOE, (all upper case) or worse yet to jaNe dOe, (crazy mixed case)? All of these display because that is how the data is stored in the table. But that means nothing to the end user. They don’t remember entering it in in some crazy case, but if you display it in an email in that crazy case – they will see it. And they will judge you for it.
The good news is that it is really easy to fix with AMPscript. The ProperCase() function is what you would use. This function capitalizes the first letter character, any following character after another letter character stays in lowercase, any letter character following a non-letter character is also capitalized. Check out the examples for a better understanding.
Please note = the system doesn’t know when a 2nd letter in the name should be capitalized. So if you use the function on a name like “McDonald” it will change it to “Mcdonald”.
SYNTAX
ProperCase(@String)
Definition of parts —
STRING = This is the string you want to be changed. It can be passed as a @variable or in “string format”
Simple Examples:
ProperCase(“jane doe”) → Jane Doe
ProperCase(“JANE DOE”) → Jane Doe
ProperCase(“jaNe dOe”) → Jane Doe
ProperCase(“jane asked a question”) → Jane Asked A Question
Advanced Example 1 – AMPscript Block:
%%[ VAR @firstname set @firstname= [First Name] set @firstname= ProperCase(@firstname)
]%%
Dear%%=v(@firstname)=%%
Advanced Example 2 – Inline:
%%[
VAR @firstname
set @firstname= [First Name]
]%%
Dear %%=ProperCase(@firstname)=%%
References:
Hi, I have two fields firstname and lastname as seperate fields. I have to write Dear Firstname Lastname . Could you please suggest. how to write propercasae where it takes only one input. Now i wrote like %%firstname%% %%Lastname%%. But i want initial letter capitol. Could you please suggest. Thanks
Thanks for the comment. The function you want to use is Concat() – Your use case is included in “Piecing it together with Concat()“