Data Manipulation and Editing

 

: (Window Assignment)

Assign a formula to a Window

>> << & ~ bitor (Bit Operators)

Bit left shift, bit right shift, bit and, bit complement, bit or operators

+= -= /= *= >>= <<= &= |=

(Assignment Operators) Operate and assign the value of an expression

APPEND

Append multiple series in place

CIRCSHIFT

Circularly shift a series

CLIP

Set outliers to min and max Y values

CONCAT

Concatenate series (end to end)

COPYDATA

Copy data in current window to clipboard

CUT

Cut the displayed contents of a Window

DECILP

Band limited series decimation

DECIMATE

Linearly remove points from a series

DELAY

Delay a series by N number of points

DELETE

Eliminate points based on condition

DELETECOL

Delete one or more columns from a table

DELETEROW

Delete one or more rows from a table

DELMATCH

Remove values of a series found in another series

EDIT

Edit Y values point by point

EXTRACT

Extract a section of a series

EXTRACTWIN

Extract a section of a series from multiple Windows

FINDCOL

Finds a column that meets a condition

FINDROW

Finds a row that meets a condition

INSERT

Insert values into a series as specified by explicit indices

INSERTCOL

Inserts one or more columns into a table

INTERPOLATE

Linearly add points to a series

MERGE

Splice several series together

NAFILL

Replace NAVALUES with the previous known value

OUTLIER

Remove outlier data points

PASTEDATA

Paste data from clipboard into current window

REMOVE

Remove points from a series

REMOVENA

Remove NAVALUES from a series or array

REPCOLUMN

Replicates the columns of a series

REPELEMENTS

Replicate the individual elements of a series

REPLACE

Replace values in a series based on a logical condition

REPLACECOL

Replace a column of a table

REPLICATE

Concatenate series with itself

REVERSE

Put last point in a series first

SEREXTRACT

Extract multiple sections from a series

SERMATCH

Find indices of values of a series found in another series

SERPAD

Pad a series with a specified value

SETDELTAX

Change delta-x values of the series

SETDELTAY

Change delta-y values of an array

SETNAVALUE

Set NAVALUE in a series

SETPT

Set a point in a series

SETXOFFSET

Set starting point of series

SETYOFFSET

Sets the starting Y value of an array

UNMERGE

Unmerge (de-multiplexes) an interlaced series

VALFILL

Replace a value with previous or next value

XEXTRACT

Extract a section of a series based on X values

XEXTRACTWIN

Extract a section of a series from multiple windows based on X values