Recently I needed to perform some housekeeping on a Windows folder. Part of this work required that the filenames be in lowercase. I know, in a usually case insensitive Operating System but bear with me. A search found this answer on Stackoverflow. dir <<YOUR FOLDER HERE>> -r | % { if ($_.Name -cne $_.Name.ToLower()) { […]

The problem I needed to produce a monthly sales report from a number of csv files. In effect merging 30 files into one file which then could be opened in Excel. The existing method of opening each csv file, selecting all, copying and pasting into a new document was labour intensive, error prone and boring. […]