MashZone NextGen 10.2 | Appendix | Operators | Data transformation operators | Extract 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
Start index
Start position of the string to be extracted.
Source: Source column, single-value operator, input value, or constant.
Size >= 0;
Data type: Number
Specification: Mandatory
Length
Number of characters in the string to be extracted.
Source: Source column, single-value operator, user input, or constant.
Number of characters >= 0
Data type: Number
Specification: Mandatory
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

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