1. Conecta HUB
  2. Transformations
  3. Text strings
  4. Extract From To

Extract From To

DESCRIPTION:

Extracts the text of the SourceValue from the Condition1Value character to the Condition2Value character.

EXAMPLE:

Extract from this generic code (88-1234Z) from the character "-" to "4".

OriginValue: "88-1234Z".

Condition1Value: "-"

Condition2Value: "4".

ProcessValue: "1234"

 

CONFIGURATION:

Value Value2 Relation Relationship2 Operation Factor
- 4 Extract from to

CODE:

If SourceValue "" Then

If Condition1Value "" Then

If Condition2Value "" Then

If IsNumeric(Condition1Relation) Then

Else

Condition1Relationship = 0

End If

If IsNumeric(Condition2Relation) Then

Else

Condition2Relationship = 0

End If

Dim Position1 As Integer = 0

Dim Position2 As Integer = 0

If Condition1Value = "Start" Then

Position1 = 0

Else

Position1 = SourceValue.IndexOf(Condition1Value)

End If

If Condition2Value = "End" Then

Position2 = SourceValue.Length

Else

Position2 = SourceValue.IndexOf(Condition2Value)

End If

Dim Total As Integer = ValorOrigen.Length

ProcessedValue = SourceValue.Substring(Position1 + Condition1Relation, Position2 - Position1 + Condition2Relation)

End If

End If

How can we help?