26 April 2018

Perl: Mass Change File Extension

The following Perl Script performs a mass change file extension to files under a specific directory. In the given example, it will rename all .dat files to .prn files.

24 April 2018

Convert XLS Files to CSV From Command Line

This is how you can convert an XLS file to a CSV file using the Windows command line. You'll need to create a VBScript to do this.

Split Excel File Into Multiple Excel Files, Based on Number of Rows

Let's assume you have an Excel Spreadsheet with 30000 rows in it and you need to split it into individual Spreadsheets with 3000 rows each. You can do this by creating a VBA Script and execute it from the Excel VBA Editor.

13 April 2018

Find And Change Encoding on Files

This article describes how to find the current encoding of a file and an example of how you can change the file's encoding to the one you desire.

05 April 2018

GIT: Most Common Commands

This article describes the most common git commands, giving a short description and examples about them. You can find the full command list on this location. Here we go: