Substitute

At the difference of the action replace, 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 substitute 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';

Last edited Dec 23, 2014 at 5:00 PM by Seddryck, version 1

Comments

No comments yet.