1. Home
  2. Conecta HUB
  3. Transformations
  4. Text strings
  5. Replace

Replace

DESCRIPTION:

Checks if the Source Value string contains the Condition1Value and replaces part of that string with the indicated Factor.

EXAMPLE:

Change any value to "3

Source value: "045003157".

Processed Value: "3

If the Origin Value string is "*"

the Processed Value is equal to the Factor

 

CONFIGURATION:

Value Value2 Relation Relationship2 Operation Factor
* Replace 1

CODE:

If SourceValue "" Then

If Condition1Value = "*" Then

ProcessedValue = SourceValue.ToString.Replace(SourceValue, Factor)

Else

If SourceValue.Contains(Condition1Value) Then

ProcessedValue = SourceValue.ToString.Replace(Condition1Value, Factor)

End If

End If

Else

If Condition1Value = "*" Then

ProcessValue = Factor

Else

ProcessValue = SourceValue

End If

End If

Was this article helpful to you? Yes No

How can we help?