I have to go through roughly 700 data entries and adjust the system's data accordingly ... by hand.😑
We don't have the tools to automate this reliably, the only available tool, tells you that an error occured and what happened but not where. That would've been kinda helpful...
The problem is that the respective data object of the data entry often contains a phone number, which has to be in a standardized format ... which it is not. Every number is formatted in like 10 variations!? A dozen different separators like spaces, commas, slashes and hyphens. And it must be edited manually 😖
My solution: built a goddamn chrome extension to format the string on click. Done. Saves a few seconds each time and a lot of headache in future. Of course given the correctness of the extension.