Hi folks! Happy New Year!
A question... does anyone have a script that would work for me to somehow mass-edit all of the Constituent accounts that are all lower case letters for their names or all capital letters? As well to add a capital letter to street names? Is this something that is even possible in a script? We are running into such issues where people have created accounts online all lower case or all upper case and then when we go to pull the information for mailers it's just a MESS. And I reeeeeally don't want to clean it manually.
Thanks!
Nicki
> does anyone have a script that would work for me to somehow mass-edit all of the Constituent accounts that are all lower case letters for their names or all capital letters?
If you have access to SQL, Brian Wilbur Grundstrom wrote some very useful code to make case changes to names and various address fields:
https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_technical-9/11415/data-quality-and-cleanup/35291
Each user/org will need to create their own modified version of the above to suit different rules/needs. I use my version of it several times per week.