Tutorial by Examples: g

Count Unique values in Range

Function countUnique(r As range) As Long 'Application.Volatile False ' optional Set r = Intersect(r, r.Worksheet.UsedRange) ' optional if you pass entire rows or columns to the function Dim c As New Collection, v On Error Resume Next ' to ignore the Run-time error 457: "Th...

excel-vba • User Defined Functions (UDFs)

Big Data example

Big data is a term for data sets that are so large or complex that traditional data processing applications are inadequate to deal with them. Challenges include analysis, capture, data curation, search, sharing, storage, transfer, visualization, querying, updating and information privacy. A general...

bigdata • Getting started with bigdata

The generated HTML with automaticaly loaded assets

<!DOCTYPE html> <html lang="en-EN"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="csrf-param" content="_csrf"> <me...

yii2 • Asset management

Simple Looping

First lets get some data into a temp table named #systables and ad a incrementing row number so we can query one record at a time select o.name, row_number() over (order by o.name) as rn into #systables from sys.objects as o where o.type = 'S' Next we declare some var...

Microsoft SQL Server • Stored Procedures

More on Packages

In the Hello World, you were introduced to the package Ada.Text_IO, and how to use it in order to perform I/O operations within your program. Packages can be further manipulated to do many different things. Renaming: To rename a package, you use the keyword renames in a package declaration, as such...

ada • Packages

Using an Icon

The <use> element is often used for reuseable icons, in collaboration with the <symbol> element. That looks like this: <svg> <symbol viewBox="0 0 16 16" id="icon-star"> <path d="M16 6.216l-6.095-.02L7.98.38 6.095 6.196 0 6.215h.02l4....

SVG • use

Enroll contact in the engagement plan programmatically

AutomationMetadataProvider automationMetadataProvider = Assert.ResultNotNull(Factory.CreateObject("automation/metadataProvider", true) as AutomationMetadataProvider); var context = AutomationManager.Provider.GetAutomationContext(ID.Parse(contact.ContactId)); co...

sitecore • Engagement Automation

Generate a random number between 0 and 100

Pass an upper limit as an argument to the rand() function. Input: my $upper_limit = 100; my $random = rand($upper_limit); print $random . "\n"; Output: A random floating-point number, like... 45.8733038119139

Perl Language • Randomness

Generate a random integer between 0 and 9

Cast your random floating-point number as an int. Input: my $range = 10; # create random integer as low as 0 and as high as 9 my $random = int(rand($range)); # max value is up to but not equal to $range print $random . "\n"; Output: A random integer, like... 0 See also t...

Perl Language • Randomness

Creating a ReadOnlyCollection

Using the Constructor A ReadOnlyCollection is created by passing an existing IList object into the constructor: var groceryList = new List<string> { "Apple", "Banana" }; var readOnlyGroceryList = new ReadOnlyCollection<string>(groceryList); Using LINQ Additiona...

.NET Framework • ReadOnlyCollections

Updating a ReadOnlyCollection

A ReadOnlyCollection cannot be edited directly. Instead, the source collection is updated and the ReadOnlyCollection will reflect these changes. This is the key feature of the ReadOnlyCollection. var groceryList = new List<string> { "Apple", "Banana" }; var readOnlyGroc...

.NET Framework • ReadOnlyCollections

Warning: Elements in a ReadOnlyCollection are not inherently read-only

If the source collection is of a type that is not immutable, elements accessed through a ReadOnlyCollection can be modified. public class Item { public string Name { get; set; } public decimal Price { get; set; } } public static void FillOrder() { // An order is generated ...

.NET Framework • ReadOnlyCollections

Basic usage

Create a new JobService This is done by extending the JobService class and implementing/overriding the required methods onStartJob() and onStopJob(). public class MyJobService extends JobService { final String TAG = getClass().getSimpleName(); @Override public boolean onStart...

Android • Job Scheduling

Iterating over a range

You can easily do something to each element in a range. (1..5).each do |i| print i end # 12345

Ruby Language • Range

Getting Nearby Places from Current Location

Prerequisites Install pods in your project Install the GooglePlaces SDK Enable location services First we need to get the users location by getting their current longitude and latitude. Import GooglePlaces and GooglePlacePicker import GooglePlaces import GooglePlacePicker Add the...

iOS • iOS Google Places API

Google Analytics in cordova without any plugin.

Insert the analytics function within index.js function analytics(){ (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a...

Cordova • Google Analytics in Cordova

Break the locked lease of blob storage in Microsoft Azure

There’s no API that can break the locked lease of blob storage in Microsoft Azure . This code snippet demonstrates break the locked lease of blob storage in Microsoft Azure (PowerShell). $key = (Get-AzureRmStorageAccountKey -ResourceGroupName $selectedStorageAccount.ResourceGroupName -name $select...

azure • Azure Storage Options

Form validation using NSPredicate

NSString *emailRegex = @"[A-Z0-9a-z]([A-Z0-9a-z._-]{0,64})+[A-Z0-9a-z]+@[A-Z0-9a-z]+([A-Za-z0-9.-]{0,64})+([A-Z0-9a-z])+\\.[A-Za-z]{2,4}"; NSString *firstNameRegex = @"[0-9A-Za-z\"'-]{2,32}$"; NSString *firstNameRegex = @"[ 0-9A-Za-z]{2,32}$"; NSString *lastNa...

iOS • NSPredicate

Type of value - package "reflect"

reflect.TypeOf can be used to check the type of variables when comparing package main import ( "fmt" "reflect" ) type Data struct { a int } func main() { s:="hey dude" fmt.Println(reflect.TypeOf(...

Go • Reflection

Read with some error checking

A modern Fortran example which includes error checking and a function to get a new unit number for the file. module functions contains function get_new_fileunit() result (f) implicit none logical :: op integer :: f f = 1 do ...

Fortran • I/O