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

Extract From To Position

DESCRIPTION:

Extracts the text of SourceValue from the position indicated in Condition1Value to the position indicated in Condition2Value.

EXAMPLE:

Extract from this generic code (88-1234Z) from position 3 through 6

OriginValue: "88-1234Z".

Condition1Value: "3".

Condition2Value: "6".

ProcessValue: "1234"

 

CONFIGURATION:

Value Value2 Relation Relationship2 Operation Factor
3 6 Extract from to position

CODE:

If SourceValue "" Then

If Condition1Value "" Then

If Condition2Value "" Then

If IsNumeric(Condition1Value) Then

If IsNumeric(Condition2Value) Then

ProcessValue = SourceValue.Substring(Condition1Value, Condition2Value)

End If

End If

End If

End If

End If

How can we help?