Category: Programming

  • String Literal Cheat Sheet (Python, C#, JS)

    String Literal Cheat Sheet (Python, C#, JS)

    Python Python uses f-strings for string interpolation. Here’s an example: In this code, the variables name and age are inserted into the string using curly braces {}. C# C# uses string interpolation with the $ symbol. Here’s an example: In this code, the variables name and age are inserted into the string using curly braces {}. JavaScript JavaScript uses template literals for string interpolation. Template literals are…

  • How to Push Your Git Repository to TFS

    How to Push Your Git Repository to TFS

    In this guide, we’ll walk through the steps of pushing your Git repository to Team Foundation Server (TFS). This guide assumes that you’re working with a Git repository. If your project isn’t already in a Git repository, you’ll need to initialize a new Git repository for your project. Step 1: Add the TFS Remote in…

  • Fixing inconsistently formatted Australian mobile numbers… in excel! 😎

    Fixing inconsistently formatted Australian mobile numbers… in excel! 😎

    Here is the excel formula: This formula checks if the first character of cell M2 is 0. If it is, it concatenates “+61” with the rest of the characters in M2 except the first one. If not, it checks if the first three characters of cell M2 are “+61”. If they are, it returns M2.…

  • How to add a remote folder share as a remote git repository in vs code?

    How to add a remote folder share as a remote git repository in vs code?

    In some cases, you might just wanna push your code to a network folder and use that as your remote. This will also work without vscode as long as you can get to the command line and you have the necessary folder permissions. Here is how 👍 First you will need to initialise your remote…

  • Simple way to sort dates in any format with jquery.datatables

    Simple way to sort dates in any format with jquery.datatables

    Initially, I was formatting the date in my table using any format I liked. However, I soon realized that this would ruin sorting. For example, if you have a table with dates formatted as “dd/mm/yyyy” and “mm/dd/yyyy”, datatables will sort them incorrectly because it will sort them based on their underlying serial numbers. Then I…

  • Converting from DOCX to PDF for thumbnails

    Converting from DOCX to PDF for thumbnails

    I recently needed to show some thumbnails of docx files online. Here is what I came up with. Please note that this will not create a perfect thumbnail. In fact its quite basic. It allows the user to simply see that the file contains something. Nevertheless, I hope you find it helpful! Here is the…

  • 🌎💻 Converting Lat Lng to XY Coordinates: A Guide

    🌎💻 Converting Lat Lng to XY Coordinates: A Guide

    As someone who works with geographic data, I often need to manipulate latitudes and longitudes. Recently, a researcher requested that I convert a list of latitudes and longitudes to XY coordinates to obscure the actual location of the points while still allowing for analysis of the distance relationship between them. Here’s how I did it,…

  • 📅 How to Format and order dd-mm-yyyy Dates in jQuery DataTables 📅

    📅 How to Format and order dd-mm-yyyy Dates in jQuery DataTables 📅

    If you’ve ever worked with DataTables, you may have encountered issues with how dates are displayed. By default, DataTables will display dates in a format that may not be easily readable or sortable. However, with a few simple tweaks, you can format your dates to display exactly how you want them. First of all your…

  • Title: How to Add a Windows 10 Machine as a Backup Repository in Veeam Backup & Replication

    Title: How to Add a Windows 10 Machine as a Backup Repository in Veeam Backup & Replication

    As an IT administrator, one of your top priorities is to ensure that your organization’s data is properly backed up and protected against data loss. Veeam Backup & Replication is a powerful backup and recovery solution that can help you achieve this goal. However, adding a Windows 10 machine as a backup repository in Veeam…

  • 🗺️🔍🏞️ Understanding Leaflet Map Events and Local Storage: How to Save and Load Map Bounds 🗺️🔍🏞️

    🗺️🔍🏞️ Understanding Leaflet Map Events and Local Storage: How to Save and Load Map Bounds 🗺️🔍🏞️

    Leaflet is a powerful open-source JavaScript library that enables developers to create interactive maps with a range of tools and functionalities that can be customized to meet specific requirements. One of Leaflet’s essential features is the ability to save and load map bounds, which can be useful for various scenarios. In this blog post, we…