Tutorial by Examples

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...

To install a new library into the Arduino IDE: Open Sketch Menu > Include Library > Manage Libraries. Once you have opened the Library Manager you can use the menu in the top to filter the results. Click on the library you want, select a version in the drop down menu, and click...

Once you have installed a library, you need to include it in your sketch in order to use it. Open the Sketch Menu > Include Library and click the Library you want to include. Now, the IDE has generated the required inclusion tags into your code. Now the Library is included in your ...

Using DYNAMIC-FUNCTION or the CALL-object you can dynamically call functions. DEFINE VARIABLE posY AS INTEGER NO-UNDO. DEFINE VARIABLE posX AS INTEGER NO-UNDO. DEFINE VARIABLE OKkeys AS CHARACTER NO-UNDO INIT "QLDRUS". DEFINE VARIABLE Step AS INTEGER NO-...

The following updates a User object via a PUT request and prints the status code of the request: package main import ( "bytes" "encoding/json" "fmt" "net/http" ) type User struct { Name string Email string } func main...