24 August 2018

Java: Use Arial Fonts as Default Swing Fonts on Linux

I guess we all agree that sometimes the default fonts that Java uses on Linux are pretty ugly, doesn't it ? This issue may cause also problems when implementing GUI projects on Linux that will be used later on Windows machines: The default font used on Linux may have different dimensions / outlook than the fonts used on Windows, causing differences in the flow of text or / and messing up components in windows.

15 June 2018

Linux: How To Kill A Zombie Process

A "Zombie Process" is a Child process who exited unexpectedly before the Parent process, so the Parent process does not grab the status of child process using wait() or waitpid() system calls. This means that the Child process is in "Zombie" state. Zombies and Orphan processes are not the same thing: While a Zombie is a defunct Child Process, the Orphan is a process whose Parent process has been killed and inherited by init process.

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: