Tutorial by Examples: l

Read from a CSV file and insert data into a table

First, you need to prepare the environment by creating the SQL Server table and the CSV file. Run the script below in SQL Server to create the SQL table either on a new database or an existing one. For this example, I used my ‘TrainingDB’ database. /* Creates table for Students.csv */ CREATE TABL...

ssis • Read from a CSV file

This have to be in a Class module, examples later referred as "Random"

' How To Seek Past VBA's 2GB File Limit ' Source: https://support.microsoft.com/en-us/kb/189981 (Archived) ' This must be in a Class Module Option Explicit Public Enum W32F_Errors W32F_UNKNOWN_ERROR = 45600 W32F_FILE_ALREADY_OPEN W32F_PROBLEM_OPENING_FILE W32F_FILE_ALREAD...

VBA • Reading 2GB+ files in binary in VBA and File Hashes

Code for Calculating File Hash in a Standard module

Private Const HashTypeMD5 As String = "MD5" ' https://msdn.microsoft.com/en-us/library/system.security.cryptography.md5cryptoserviceprovider(v=vs.110).aspx Private Const HashTypeSHA1 As String = "SHA1" ' https://msdn.microsoft.com/en-us/library/system.security.cryptography.sha1c...

VBA • Reading 2GB+ files in binary in VBA and File Hashes

Calculating all Files Hash from a root Folder

Another variation from the code above gives you more performance when you want to get hash codes of all files from a root folder including all sub folders. Example of Worksheet: Code Option Explicit Private Const HashTypeMD5 As String = "MD5" ' https://msdn.microsoft.com/en-us/libr...

VBA • Reading 2GB+ files in binary in VBA and File Hashes

Creating Singleton class and also preventing it from having multiple instances using alloc/init.

We can create Singleton class in such a way that developers are forced to used the shared instance (singleton object) instead of creating their own instances. @implementation MySingletonClass + (instancetype)sharedInstance { static MySingletonClass *_sharedInstance = nil; static dispa...

Objective-C Language • Singletons

Simple Example of A* Pathfinding: A maze with no obstacles

Let's say we have the following 4 by 4 grid: Let's assume that this is a maze. There are no walls/obstacles, though. We only have a starting point (the green square), and an ending point (the red square). Let's also assume that in order to get from green to red, we cannot move diagonally. So, s...

algorithm • A* Pathfinding Algorithm

A* Pathfinding through a maze with no obstacles

Let's say we have the following 4 by 4 grid: Let's assume that this is a maze. There are no walls/obstacles, though. We only have a starting point (the green square), and an ending point (the red square). Let's also assume that in order to get from green to red, we cannot move diagonally. So, s...

algorithm • A* Pathfinding

Merge Sort Implementation in Go

package main import "fmt" func mergeSort(a []int) []int { if len(a) < 2 { return a } m := (len(a)) / 2 f := mergeSort(a[:m]) s := mergeSort(a[m:]) return merge(f, s) } func merge(f []int, s []int) []int { var i, j int size :...

algorithm • Merge Sort

Simplest package

Here we are sharing some minimal workflow to build and publish an Angular 2+ npm package. Configuration files We need some config files to tell git, npm, gulp and typescript how to act. .gitignore First we create a .gitignore file to avoid versioning unwanted files and folders. The content is: ...

Angular 2 • Create an Angular 2+ NPM package

Migrating from Gradle using Groovy script to Kotlin script

Steps: clone the gradle-script-kotlin project copy/paste from the cloned project to your project: build.gradle.kts gradlew gradlew.bat settings.gradle update the content of the build.gradle.kts based on your needs, you can use as inspiration the scripts in the project just clo...

Kotlin • Configuring Kotlin build

Hello World

The following example will demonstrate a basic installation and setup of RequireJS. Create a new HTML file called index.html and paste the following content: <!DOCTYPE html> <html lang="en"> <head> <title>Hello RequireJS</title> <script type=&...

requirejs • Getting started with requirejs

Breaking a loop

A loop will execute as long as its condition remains true, but you can stop it manually using the break keyword. For example: var peopleArray = ["John", "Nicole", "Thomas", "Richard", "Brian", "Novak", "Vick", "Amanda",...

Swift Language • Loops

Hello World with Nested Dependencies

The following example expands upon Hello World by demonstrating multiple dependencies using the define() function. Create a new HTML file called index.html and paste the following content: <!DOCTYPE html> <html lang="en"> <head> <title>Hello RequireJS</t...

requirejs • Getting started with requirejs

Obfuscated Email Formatter

In our example we will be creating a customized formatter for email addresses that will allow us to display obfuscated email addresses to fool those nasty spammers. The formatter will have a some configuration options that will allow us to control how the email address is obfuscated: Remove @ an...

drupal • Field Formatter

Incorporating Non-AMD Libraries

Not all libraries are defined in a way that is compatible with AMD and RequireJS's define() function. The author's have addressed this by including a shim directive for configuring those dependencies. One example is using the jQuery UI Layout Plugin. That plugin depends on jQuery. You can configu...

requirejs • Getting started with requirejs

Conditional blocks

Parts of template can be displayed conditionally. If statement is used for this purpose. It's similar to if statement in programing languages. Contents of block are executed/displayed if an expression evaluates to true. {% if enabled == false %} Disabled {% endif %} Disabled will be displ...

twig • Basic template syntax

Installation or Setup

Detailed instructions on getting corona set up or installed.

corona • Getting started with corona

CloudCannon hosting (and CMS)

CloudCannon offers hosting and a CMS for Jekyll applications. Here are the steps in hosting your Jekyll application on CloudCannon (http://cloudcannon.com). Without version control: Create your blog locally using some local files and jekyll serve Create a CloudCannon account and create a new si...

jekyll • Hosting

Getting an instance of UIStoryboard programmatically

SWIFT: Getting an instance of UIStoryboard programmatically can be done as follows: let storyboard = UIStoryboard(name: "Main", bundle: nil) where: name => the name of the storyboard without the extension bundle => the bundle containing the storyboard file and its relate...

iOS • UIStoryboard

Planning for localization : enable RTL support in Manifest

RTL (Right-to-left) support is an essential part in planning for i18n and L10n. Unlike English language which is written from left to right, many languages like Arabic, Japanese, Hebrew, etc. are written from right to left. To appeal to a more global audience, it is a good idea to plan your layouts ...

Android • Internationalization and localization (I18N and L10N)