Sometimes the simplest thing is really taken for granted and we take the long route to do the simplest thing. We received a CSV with thousands of ID numbers that will be used to update a database table. The data would look like the following: The goal is just to add a comma at the end of each line so it can be used to update data in a database table. In the past, we would probably … [Read more...]
How to Reassign Column Selection Shortcut Keys in Sublime Text
Following the previous post on assigning a new keyboard shortcuts for column selection, this time we're going to the same thing in Sublime Text. As always, before you make any changes, make sure you backup everything. macOS (OSX) On the top menu, click on Sublime Text -> Preferences -> Key Bindings and a split screen will open. Using the same key combination as in the example … [Read more...]
How to Use Your Favorite Text Editor in Git
After installing Git and initially configuring it, you can further configure it to use your favorite text editor as the default. What you need to do is set the value of core.editor to the program file of your editor and add a flag -w at the end. The -w basically is to tell Git to wait until all operations within the text editor is done before Git can continue to do its thing … [Read more...]
How to Install Sublime Text in Linux
This short tutorial is based on the link provided on the bottom of this post with slight modifications. The example is shown with 64-bit version of Linux Mint. Download Sublime Text Open your browser and go to Sublime Text and download the file to directory Downloads. Setup Open Terminal and type in the following command: Then type in this command to extract the file: Once the … [Read more...]