Substring transformation

A transformation type Substring will transform data from the incoming file by selecting a subset of the string. The value for Start position is required and defines the start position of the string. The value for End Position is optional and defines the end position of the string. The value of the end position must be higher than the value of the start position. The start position is inclusive, so zero is the start position for the first character of a string. The end position is exclusive.

Example: If you have the string “Johnathan” and select 3 for Start position and 8 for End position, the transformed data will be “natha”. If only the start position is defined as 3 without an end position, the transformed data will be "nathan".

To configure a substring transformation:

  1. Locate the data model attribute you want transformed and click its Transform link. The Transform dialog is displayed, and it shows the source fields (source) and schema attributes (target).
  2. An image of the Transform link

  3. Use the Transformation type list to select Substring.
  4. An image of the Transfomration type drop-down list

  5. In the Start position field, use the arrows to select a value. The first position is zero. Optionally, select an end position in the End position field. Values for the end position must be higher than values for the start position.
  6. An image of the start position and end position fields

  7. Optionally, test the transformation by entering a value in the Sample input field. The transformed value will display in the Output field.
  8. An image of the replace field for null/empty values

  9. Click Apply.

Learn more

Creating ingest jobs

Concatenation transformation

Date transformation

Lookup/static transformation

URL transformation

Hash transformation

Prefix-Suffix transformation

Replace transformation

Trim transformation

Padding transformation

RegEx Advanced transformation

transform, transformation, substring, substring transformation, ingest job