Blog

JavaScript RegExp – Match Any Character

If you have used regular expressions in JavaScript before you probably know that you can match any non-line-terminating character with just the dot (/./). Of course, you may also want to match absolutely any character in which case you can use any of the following: Most Common: /[\S\s]/ This is […]

By Chris West, ago
Blog

PostgreSQL – Most Recent Week Day

Most Recent Week Day Recently I was reviewing someone’s code for a function in PostgreSQL and I saw a block that was supposed to calculate the most recent Friday of the week. After working on improving it I came up with the following queries that will show the most recent […]

By Chris West, ago
Blog

Excel to CSV, TSV and JSON Converter

I recently finished creating a Desktop application that can converter Excel files into CSV, TSV and JSON files. This application allows you to select a root folder containing all of the Excel files that you want to convert then you can convert all of the sheets in each Excel file. […]

By Chris West, ago
Blog

JavaScript Snippet – suffixFileSize()

If you would like to convert the amount of bytes (or bits) into the corresponding measure when the size is a kilobyte or bigger (or a kilobit or bigger) you can use the following JavaScript function: Here are some examples of using it: // Convert bytes console.log(suffixFileSize(1023)); // 1023 B […]

By Chris West, ago
Blog

Google Sheets Data As JSON & JSONP

Google Sheets is a pretty simple way to make free spreadsheets and to quickly store data. Did you know that you can actually retrieve this data via JSON & JSONP? Here’s how you can do it in just a few easy steps: Open the desired Google Spreadsheet. Go to File […]

By Chris West, ago
Blog

Ciphly – Top Programming Resources

If you want to either look for the top programming resources on the web or add your link, visit the brand new site Ciphly.com. The Top Sites You Want To See! This new site allows you to see the top programming resources by language and category (library, documentation, etc.). Scoring […]

By Chris West, ago
Blog

Search Engine Using Google Sheets

Have you ever wanted to make a simple search engine? There are plenty of ways to do it. One way that I have been using in my simple search engine for a while is leveraging Google Sheets. Creating Your Own Google Sheets Search Engine Here are a few simple steps […]

By Chris West, ago