By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
the product descriptions are all in uppercase. I have created an application
which takes the product description and creates a letter document which
contains a computed field with the product description in proper case.
However, moaned my user, we don't want it to say Mcdougalls, we want it to say
This small formula does the job for any string which may contain mcdougalls as
it's first word. Variations of this could be used for any of those annoying
Note that Prodname needs to be replaced with the field you are converting...
@If(@UpperCase(@Left(ProdName;10))="MCDOUGALLS" ; "McDougalls " +
@ProperCase(@Right(Prodname; " ")) ; @ProperCase(Prodname) )