DriveWorks Pro 22

SppReplaceInTable

SppReplaceInTable

Returns a Table Array with matching search items replaced with a new value in the given column.

Syntax

SppReplaceInTable ([Table Array],[Column],[Search Text],[Replace Text],[Exact Match])

Where:

Table Array is a Table Array such as the data in a standard Table or the result of the QueryDataValues Function.

Column is the column on which to set the value. A number starting at 1 for the first column.

Search Text is the text to look for in the specified column.

Replace Text is the text to replace for each row where the search text is found in the specified column.

Exact Match is TRUE to only replace where there is an exact match, FALSE to replace if the search text is contained in the Table value.

Example

Example Data