DriveWorks Pro 22

SppFindAndReplaceInTable

SppFindAndReplaceInTable

Returns a table with matching items replaced with new items from a given search table.

Syntax

SppFindAndReplaceInTable([Table Array],[Column],[Include Header In Data to Search],[Include Header In Results],[Table Containing Find And Replace Strings])

Where:

Table Array is a table array such as the data in a standard table or the result of the QueryDataValues function.

Column To Search is the column in which to set the value. A number starting at 1 for the first column, or 0 to find and replace across all columns.

Include Header In Data to Search is TRUE to include header values in the data that is being searched.

Include Header In Results is TRUE to use the same headers as the first row of results.

Table Containing Find And Replace Strings is a 2 column table array (such as the data in a standard table, or the result of a QueryDataValues function), where the first column contains the text to find and the second column is the text to replace.

Example

Example Data

DWLookupProductData

DwLookupFindAndReplace

Example Result