Tutorial by Examples: n

BEGINS - returns TRUE if one string begins with another string. string1 BEGINS string2 If string1 BEGINS with (or is equal to) string2 this will return true. Otherwise it will return false. If string two is empty ("") it will always return true. BEGINS is very useful in queries wher...
There are standard functions built in for comparing equality, inequality etc. NameSymbolAlternativeExampleEqual=EQi = jNot equal<>NEi <> jLess than<LTi < jless than or equal<=LEi <= jGreater than>=GTi > jGreater than or equal≥=GEi >= j The symbol can be exchanged w...
RANDOM - generates a random number RANDOM(low, high) Generates a pseudo random integer between low and high // Example that generates 20 random numbers between 1 and 20 (1 and 20 included) DEFINE VARIABLE i AS INTEGER NO-UNDO. DO i = 1 TO 20. DISPLAY i RANDOM(1, 20). PAUSE. ...
Python includes a profiler called cProfile. This is generally preferred over using timeit. It breaks down your entire script and for each method in your script it tells you: ncalls: The number of times a method was called tottime: Total time spent in the given function (excluding time made in c...
Better MID() and other string extraction examples, currently lacking from the web. Please help me make a good example, or complete this one here. Something like this: DIM strEmpty as String, strNull as String, theText as String DIM idx as Integer DIM letterCount as Integer DIM result as String ...
Write a CSV file from a dict or a DataFrame. import pandas as pd d = {'a': (1, 101), 'b': (2, 202), 'c': (3, 303)} pd.DataFrame.from_dict(d, orient="index") df.to_csv("data.csv") Read a CSV file as a DataFrame and convert it to a dict: df = pd.read_csv("data.csv&qu...
Installing Before you can do anything using the Rust programming language, you’re going to need to acquire it—either for Windows or by using your terminal on Unix-like systems, where $ symbolizes input into the terminal: $ curl https://sh.rustup.rs -sSf | sh This will retrieve the required file...
UIRefreshControl *refreshControl = [[UIRefreshControl alloc] init]; [refreshControl addTarget:self action:@selector(pullToRefresh:) forControlEvents:UIControlEventValueChanged]; self.scrollView.alwaysBounceVertical = YES; [self.scrollView addSubview:refreshControl]; - (void)pullToRefresh:(UIRe...
If you start your application on Linux, use the proxy for debugging via port, for example: socat TCP-LISTEN:9958,fork TCP:127.0.0.1:5858 & Use port 9958 for remote debugging then.
Swift 3 import UIKit // Save String to file let fileName = "TextFile" let documentDirectory = try FileManager.default.urlForDirectory(.documentDirectory, in: .userDomainMask, appropriateFor: nil, create: true) var fileURL = try documentDirectory.appendingPathComponent(fileName).ap...
A common mistake MATLAB coders have, is using the length function for matrices (as opposed to vectors, for which it is intended). The length function, as mentioned in its documentation, "returns the length of the largest array dimension" of the input. For vectors, the return value of leng...
As mentioned before strings are normally case insensitive but that only regards comparison of strings. There's built in functions for changing case. CAPS (string) Makes string upper case LC(string) Makes string lower case DEFINE VARIABLE c AS CHARACTER NO-UNDO. DEFINE VARIABLE d AS C...
You can create you own Scala annotations by creating classes derived from scala.annotation.StaticAnnotation or scala.annotation.ClassfileAnnotation package animals // Create Annotation `Mammal` class Mammal(indigenous:String) extends scala.annotation.StaticAnnotation // Annotate class Platypus...
require 'maruku' str = " # Title * List 1 * List 2 * List 3 " markdown = Maruku.new(str) puts markdown.inspect
require 'maruku' str = " # Title * List 1 * List 2 * List 3 " markdown = Maruku.new(str) puts markdown.to_html_document
require 'json' data = {"test" => 123} puts JSON.generate(data)
require 'json' document = "{\"test\":123}" puts JSON.parse(document)
require 'json' data = JSON '{"test":23}' # => {"test"=>23} or require 'json' data = JSON['{"test":23}'] # => {"test"=>23}
require 'json' document = JSON 'test' => 23 # => "{\"test\":23}" or require 'json' document = JSON['test' => 23] # => "{\"test\":23}"
Here, a cursor is used to loop through all databases. Futhermore, a cursor from dynamic sql is used to query each database returned by the first cursor. This is to demonstrate the connection-scope of a cursor. DECLARE @db_name nvarchar(255) DECLARE @sql nvarchar(MAX) DECLARE @schema nvarcha...

Page 909 of 1088