Fields string table

Fields string table in Replace in string

You can specify the replacement string and select options pertaining to it in the following table.

Column	Description
In stream field	Specify the field to replace from the PDI input stream. Click Get Fields to add all fields from the input stream(s).
Out stream field	Specify the new field name to output to the PDI stream.
use RegEx	Select Y (Yes) or N (No) to indicate whether to use a regular expression to search for values.
Search	Specify whether to search for matched values of this string.
Replace with	Specify the string to replace the matched value.
Set empty string?	Select Y (Yes) or N (No) to indicate whether to replace null values with empty strings.
Replace with field	Specify a field value that will be used to replace the matched value.
Whole Word	Select Y (Yes) or N (No) to indicate whether to replace the entire word of the matched value.
Case sensitive	Select Y (Yes) or N (No) to indicate whether the search is case sensitive.
Is Unicode	Select Y (Yes) or N (No) to indicate whether the search value is a sequence of Unicode characters.

Use Get Fields to add all fields from the PDI input stream.