Replace transformation

A transformation type of Replace will transform data from the incoming file by replacing all occurrences of a defined value in a string, or only the first occurrence of a value in a string.

Example: If you replace all occurrences of “J” with “j” in “John James”, you get “john james”. If you select to replace the first occurrence in this string, you will get “john James”

To configure a replace 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 Replace.
  4. An image of the Transfomration type drop-down list

  5. Select if you want to replace all occurrences or only the first occurrence.
  6. An image of the replace all or first occurrence options

  7. In the Original value field, enter the value that you to replace. In the New value field, enter the value you want to replace the original value. You have the option of leaving the New value field blank. Values you enter in both fields are case-sensitive.
  8. An image of the original value and new value fields

  9. Optionally, test the transformation by entering a value in the Sample input field. The transformed value will display in the Output field.
  10. An image of the fields used for testing the transformation

  11. Click Apply.

Learn more

Creating ingest jobs

Concatenation transformation

Date transformation

Lookup/static transformation

URL transformation

Hash transformation

Prefix-Suffix transformation

Substring transformation

Trim transformation

URL transformation

Padding transformation

RegEx Advanced transformation

transform, transformation, replace, replace transformation, ingest job