Substitutes text found in a column in the provided table.
TableSubstitute([Table], [Column Index], [Old Text], [New Text], [Which Instance], [Ignore Case])
Where:
Table is the table from which to substitute text.
Column Index is the index of the column to have text substituted.
Old Text is the old text within the column to be substituted.
New Text is the new text that is to substitute the old text.
Which Instance (optional) is a number representing the occurrence of the old text that is to be replaced. 0 means every occurrence of the old text will be replaced.
Ignore Case (optional) is TRUE to ignore case when replacing.
| Rule | Meaning |
|---|---|
| TableSubstitute(DWGroupTableCustomers, 1, "Amazon Warriors", "Amazon Warriors Inc.", 0, TRUE) | Will return an array of the table Customers with the old text "Amazon Warriors" replaced with "Amazon Warriors Inc.". |
Customers Table
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
Customers Table
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors Inc. | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
DriveWorks will return the table above as an array, which will look like:
| Table returned as an Array |
|---|
| {"CustomerName","City","Country";"Amazon Warriors Inc.","Paris","France";"Bolton Burners","Concord","United States";"Boston Bulls","Hanover","Germany";"Cambridge Cats","Toulouse","France"} |