topic Re: Is there a standard DT scenario for Proper Case cleanup? in DemandTools

Is there a standard DT scenario for Proper Case cleanup?

LizK — Tue, 10 Jun 2025 13:03:57 GMT

I know there is a standard out of the box DT scenario for doing Proper Case cleanup for Account object. I'm looking for same thing for Contact but haven't been able to find it yet. I don't want to do the clean up via TUNE, I want to do the cleanup via Modify. Tks! LizK

Re: Is there a standard DT scenario for Proper Case cleanup?

LizK — Tue, 10 Jun 2025 13:36:05 GMT

Ok - stumbled my way into formula area and found ProperCaseName. Looked like perfect thing to use. But screen shot attached shows it failed to work. Error says there is a syntax error. Any advice appreciated.

Re: Is there a standard DT scenario for Proper Case cleanup?

Pugs_Validity — Tue, 10 Jun 2025 18:37:07 GMT

Hey Liz - I'm unable to see the image you posted but this article from our knowledge base should help clarify things for you. Feel free to also look through the Formula Dictionary at the list of various standardizations you can do from propercasing names, to standarding phone numbers and addresses. If you need help formatting a specific formula, feel free to always shoot us an email to DemandToolsCOE@validity.com. Thanks!

Re: Is there a standard DT scenario for Proper Case cleanup?

LizK — Tue, 10 Jun 2025 18:58:43 GMT

Hi. Sorry image was not visible. Weird. Anyway I tried throwing in the ProperCaseNameForceAll formula and that seemed to work. So all set for the moment. Appreciate the fast response. LizK