DADiSP Online Help
Click here to see this page in full context

DADiSP Worksheet Functions > Function Categories > Data Manipulation and Editing > REPLACECOL

 

REPLACECOL

Purpose:

Replaces a column of a table.

Syntax:

REPLACECOL(series, newcol, colnum)

series

-

A multi-column series.

newcol

-

A series, the new column to replace the existing column.

colnum

-

Optional, an integer,  the column number to replace.

If colnum < 1, a new column is inserted before the first column.

If colnum > numcols, a new column is appended after the last column. Defaults to numcols+1, append new column to table.

Returns:

A series or table.

Example:

W1: reshape(1..10, {3, 5, 2})

W2: replacecol(W1, 1..3)

W3: replacecol(W1, 1..3, 2)

W4: replacecol(W1, 1..3, 3)

 

W1 contains the table:

 

1   4   9

2   5  10

3   6

    7

    8

 

W2 contains the table:

 

1   4   9   1

2   5  10   2

3   6       3

    7

    8

 

W3 contains the table:

 

1   1   9

2   2  10

3   3

 

W4 contains the table:

 

1   4   1

2   5   2

3   6   3

    7

    8

Example:

W1: reshape(1..10, {3, 5, 2})

W2: replacecol(W1, ones(2, 2), 2)

 

W1 contains the table:

 

1   4   9

2   5  10

3   6

    7

    8

 

W2 contains the table:

 

1   1   1   9

2   1   1  10

3              

Remarks:

REPLACECOL does not operate in-place, a new series is returned.

 

As shown in the second example, if the new series contains multiple columns, all of the new columns replace the original column.

 

See INSERTCOL to insert one or more columns into a table.

See Also:

COLEXTRACT

DELETE

DELETECOL

DELETEROW

INSERTCOL

RAVEL

REMOVE

REPLACE

RESHAPE