Returns a table with matching search items replaced with a new value in the given column.
SppReplaceInTable ([Table Array],[Column],[Search Text],[Replace Text],[Exact Match])
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.
|SppReplaceInTable(DWLookupProductData,4,"Roller","Heavy Duty Roller",FALSE)||Will replace all items in column 4 of the table ProductData that contain Roller with Heavy Duty Roller.|