At the difference of the action
, the action substitute
doesn't replace the whole content of a cell but only a part of it. It has the same definition than the function
in excel or replace
in SQL and .Net
You need to specify in which column to look for, the substring to be replaced and the new value. These information will define correctly your action.
case substitute into column 'beta' value 'bar' with value 'foo';
Referring to the content of other columns
It's possible to use the content of other columns to define the value to be replaced or the value of substitution. For each row, the value of the column defined in the action will be used in place of a fixed value. It's possible to define a column in
place of a value for the substring to replace or the the replacing substring or both.
case substitute into column 'beta' column 'alpha' with value 'foo';
case substitute into column 'beta' column 'alpha' with value 'gamma';
case substitute into column 'beta' value 'bar' with column 'gamma';