MashZone NextGen 10.2 | Appendix | Operators | Data transformation operators | Replace text | Parameters
 
Parameters
The following parameters are available.
Parameter
Description
Column
Name of the column whose values are searched.
Source: Source table
Data type: Text
Specification: Mandatory
Search text
String for which the search is performed.
Source: Column values from source table, single value from a feed (single-value operator), input value, or a constant.
Data type: Text
Specification: Mandatory
Replacement text
String that replaces the search text.
Source: Source table, single-value operator, input value, or constant.
Data type: Text
Specification: Optional
If no replacement text is specified, the search text found is replaced with a empty text.
Target column
Name of the column to which the search result is written. This can be either a new column (typing a column name in the text field) or existing column (selecting a column from the drop-down menu).
Data type: Number
Default value: Result_1
Specification: Mandatory
First/last hit
IF multiple results are found, the first, last, or all hits is/are replaced.
The specification relates to occurrence within the individual rows of the search column and not to the sequence of rows, i.e., NOT "First row", "Last row" and "All rows".

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release