Tutorial by Examples: p

Update Rev Rec Dates and Rule

/** * Save the results from the saved search as .csv and store in file cabinet * Get the file's internal id when loading the file * Use \n to process each row * Get the internal id and whatever columns that need updating * Create a filtered search and pass the internal id * If the passe...

netsuite • SuiteScript - Process Data from Excel

Extract specific column/field from specific line

If you have the following data file cat data.csv 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 maybe you need to read the fourth column of the third line, this would be "24" awk 'NR==3 ...

awk • Row Manipulation

Ploting time series

This example illustrates how to plot a time series of temperature from a csv data file. library(ggplot2) # Original data not provided, see subset/plotted data below datos.orig<-read.csv("data.csv",header=TRUE) # read csv data # Change dates to POSIXct fecha<-as.data.frame(a...

ggplot2 • Plotting time series

@Input()

Parent Component : Initialize users lists. @Component({ selector: 'parent-component', template: '<div> <child-component [users]="users"></child-component> </div>' }) export class ParentComponent implements OnInit{ let users...

Angular 2 • Angular2 Databinding

Adding a MPVolumeView

// Add MPVolumeView in a holder view let mpVolumeHolderView = UIView(frame: CGRect(x: 0, y: view.bounds.midY, width: view.bounds.width, height: view.bounds.height)) // Set the holder view's background color to transparent mpVolumeHolderView.backgroundColor = .clear let mpVolume = MPVolumeView(fr...

iOS • MPVolumeView

Switch among Child Frames of a Parent Frame.

Consider you have a Parent Frame(Frame-Parent). and 2 child frames(Frame_Son,Frame_Daughter). Lets see various conditions and how to handle. 1.From Parent to Son or Daughter: driver.switchTo().frame("Frame_Son"); driver.switchTo().frame("Frame_Daughter"); 2.From Son to Pa...

selenium-webdriver • Switching Frames

Setup for CentOS7 / RHEL7

This example assumes two servers: dbserver (where our database lives) appclient (where our applications live) FWIW, both servers are SELinux enforcing. First, log on to dbserver Create a temporary directory for creating the certificates. mkdir /root/certs/mysql/ && cd /root/cer...

MySQL • SSL Connection Setup

Getting Help

You can use function help() or ? to access documentations and search for help in R. For even more general searches, you can use help.search() or ??. #For help on the help function of R help() #For help on the paste function help(paste) #OR help("paste") #OR ?paste #OR ...

R Language • Getting started with R Language

Retrieve partition table,column, scheme, function, total and min-max boundry values using single query

SELECT DISTINCT object_name(i.object_id) AS [Object Name], c.name AS [Partition Column], s.name AS [Partition Scheme], pf.name AS [Partition Function], prv.tot AS [Partition Count], prv.miVal AS [Min Boundry Value], prv.maVal AS [Max Boundry Value] FROM sys.object...

Microsoft SQL Server • Partitioning

JSP Comments Example

<!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html"> <title>JSP Comments</title> </head> <body> <%-- JSP comments --%> -- Ignored by container, you can't see this comment in source code...

jsp • Comments in JSP

Parse JSON file with Groovy

Suppose we have the following JSON data: { "TESTS": [ { "YEAR": "2017", "MONTH": "June", "DATE": "28" } ] } import groovy.json...

JSON • Parsing JSON string

How can I compile my Sass

This section is only relevant if you work with the Sass version of Materialize. First, you need to install Sass in your working directory: gem install sass When you have Sass installed on your project and you want to update your output .css file, you need to use the following command: sass sas...

materializecss • Getting started with materializecss

Add an autocomplete UI control with results controller.

The autocomplete UI control is a search dialog with built-in autocomplete functionality. As a user enters search terms, the control presents a list of predicted places to choose from. When the user makes a selection, a GMSPlace (Place in Xamarin) instance is returned, which your app can then use to ...

Xamarin.iOS • Xamarin iOS Google Places Autocomplete

Python

There are multiple ways to switch to alert pop-up in Python: Deprecated: alert = driver.switch_to_alert() Using switch_to: alert = driver.switch_to.alert Using ExplicitWait: from selenium.webdriver.common.by import By from selenium.webdriver.support.ui import WebDriverWait ...

selenium-webdriver • Handle an alert

CAST data to JSON type

This converts valid json strings to MySQL JSON type: SELECT CAST('[1,2,3]' as JSON) ; SELECT CAST('{"opening":"Sicilian","variations":["pelikan","dragon","najdorf"]}' as JSON);

MySQL • JSON

JSON Extract Operators

Extract path by -> or ->> Operators, while ->> is UNQUOTED value: SELECT myjson_col->>'$[1]' , myjson_col->'$[1]' , myjson_col->>'$[*].label' , myjson_col->>'$[1].*' , myjson_col->>'$[2].*' FROM tablename ; -- visuall: B, "B...

MySQL • Extract values from JSON type

Interrupt Handling

Interrupts are handled by a protected procedure with no parameters. ------------------------------------------------------------------ -- Interrupt Counting Package -- ------------------------------------------------------------------ with Ada.Interrupts.Names; use Ada.Interrupts.Names; packa...

ada • Task

Show more information about remote repository

You can view more information about a remote repository by git remote show <remote repository alias> git remote show origin result: remote origin Fetch URL: https://localserver/develop/myrepo.git Push URL: https://localserver/develop/myrepo.git HEAD branch: master Remote branches: ...

Git • Git Remote

Installation and Setup

Description of the installation process : Debian jessie -- Installation Guide Each architecture has his own installation guide : amd64 i386 armel s390x powerpc armhf mips AArch64 POWER. Download an iso image of the Debian distribution (stable release): Debian installer Use ...

debian • Getting started with debian

Overriding Freight Amount in Shipment and Invoice

Out of the box Acumatica allows to create and maintain the list of shipping terms in the system. Shipping terms are used to define the shipping, packaging and handling costs, depending on the shipment amount. In this example I will show how to calculate freight amount for a shipment based on sales ...

acumatica • Freight Calculation