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

Extract From

DESCRIPTION:

Extracts the text of the SourceValue from the character indicated in Factor to the end of the string.

EXAMPLE:

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

OriginValue: "88-1234Z".

Factor: "-".

ProcessValue: "1234Z".

 

CONFIGURATION:

Value Value2 Relation Relationship2 Operation Factor
Extract from -

CODE:

If SourceValue "" Then

ValorProcessed = ValorOrigen.Substring(ValorOrigen.IndexOf(Factor.Replace(Factor.Replace(Chr(34), "")) + 1, ValorOrigen.Length - ValorOrigen.IndexOf(Factor.Replace(Factor.Replace(Chr(34), ""))) - 1)

End If

How can we help?