Our metadata has grown messy over time. I am working on fixing the process that caused the mess (human produced cover sheets with either ALL CAPS or Title Case names). Once I have that solved so that the mess can no longer be created, I need to come up with a way to clean up the existing mess.
We only have a few fields per entry - Employee Name, Employee Number, Employee Type.
The Employee Name gets used as the files Name. These are all over the place as far as the letter case is concerned.
Is there someway to fix these up en mass? We do not have Workflows so I was hoping there might be a method that doesn't rely on that.
Thanks for any tips or suggestions!