Tech of the Day #1
July 1st, 2009 by wjklos | Comments Off
I had to break out some perl skills today. I was little rusty as I haven’t used it in volume for 2-3 years. However, it was the right tool for the job today. One of our rainmakers needed a favor for building a conversion table from an old Chart of Accounts to the newest version. All they had was a spreadsheet of about 4000 items where column “A” housed a formula of seemingly random numbers from column “B”. The assignments from old to new were a mixture of single elements and cell ranges that made it difficult, if not impossible to handle in Excel.