UPDATE_COLUMN

Updates a column. If a NewColumnType is specified & differs from the current column type, then all cells in the column are put through regular type coercion in addition to it's name being changed.

Syntax

UPDATE_COLUMN(targetFrame, oldColumnName, newColumnName, [newColumnType = null])

  • targetFrame - Target Frame.

  • oldColumnName - Column Name to Update.

  • newColumnName - New Column Name.

  • [newColumnType = null] - Column type.

Sample Usage

UPDATE_COLUMN(C1, "number", "point")
UPDATE_COLUMN(C1, "number", D1)

Return Value

  • TRUE if function modified the targetFrame.

  • FALSE otherwise.

Notes

In order for UPDATE_COLUMN to work, the first argument targetFrame must be a FRAME.

See Also

PreviousDELETE_COLUMNNextADD_COLUMN_BEFORE

Last updated

Was this helpful?