Replace+String Details

Element Details: Replace+String

Available in: Logi Info

Source code name: ReplaceString

Performs a case-sensitive search and replace on the specified columns.

By default the element will update the value of the original column. To save the updated string in a new column use the NewColumnNames attribute.

All occurrences of the Target string are replaced with the value of NewString. Use the Change attribute to control the scope of the search and replace. If the Target string is blank, the entire value is changed.

Element Group:String Elements

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

Change

Last

First

All

The type of transformation to apply to the column value.

ColumnNames

UserDefined

(Required) A list of column names, separated by commas. For example: OrderID, CustomerID, EmployeeID, OrderDate

UserDefined

(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.

NewColumnNames

UserDefined

A list of column names, separated by commas. The number of items in this list must match the number in the ColumnNames attribute. For example: OrderID, CustomerID, EmployeeID, OrderDate

NewString

UserDefined

A new string value.

TargetString

UserDefined

The string value to seach for.

PARENT ELEMENTS

Click element to drill down for more information.

CHILD ELEMENTS

Click element to drill down for more information.