![]() My favourite tool for this is called OpenRefine, and its specialty is "reconciling" or "normalizing"-making it easy to find typos, variations on phrases, formatting errors, extra spaces, and other things that are hard to spot in rows upon rows of information. The good news is, if you can get your messy data into a spreadsheet, you can clean up and reformat it. ![]() It was quite the chore-a chore many of us face when trying to organize data. My job was transferring everything to yet another contractor-which meant cleaning up thousands of records to play nice with the new vendor’s fancy online inventory. Add in the random mistakes that added up over time, and you had quite a mess. Storage contracts changed several times-so the box codes and vendor receipts varied over time. Most records had a box number, storage date, storage vendor receipt number, and a rough idea of the contents. Materials were indexed in a document table. I once worked for a company that stored paperwork offsite for 60 years. Ever had to manually edit dusty, messy, years-old information from some obsolete software?
0 Comments
Leave a Reply. |