DELETE

Purpose:

Deletes points from the input series if the corresponding point in the binary control series is non-zero.

Syntax:

DELETE(series, condition, naflag)

series

-

A series or table.

condition

-

Binary control series or table to determine which points to delete.

naflag

-

Optional. An integer. If 1 and all points are deleted, the result is a single point series with a value of NaN. If 0 and all points are deleted, the result is an empty series. Defaults to 0.

Returns:

A series or table.

Example:

W1: 1..5

W2: delete(W1, {1, 0, 1})

 

deletes the first and third point from W1 resulting in {2, 4, 5}.

Example:

W3: delete(W1, W1 > 2.0)

 

deletes all the points from W1 that are larger than 2.0.

Remarks:

Values can be also be deleted using the {} empty series. For example,

 

 W1[1] = {}

 

deletes the first point of W1.

 

 W1[1..10] = {}

 

deletes the first 10 points of W1.

 

By default, if all points are deleted from the series, DELETE returns an empty series. However, if naflag is 1, DELETE returns a single point series with a value of NaN.

See Also:

DELETECOL

DELETEROW

DELMATCH

DECIMATE

INSERT

OUTLIER

REMOVE

REMOVENA

REPLACE