String transformations

uppercase

version: 1
columns:
  make:
    - input: make
    - uppercase

lowercase

version: 1
columns:
  make:
    - input: make
    - lowercase

replace

version: 1
columns:
  make:
    - input: make
    - replace:
        "MERCEDES-BENZ": "MERCEDES"
        "GM": "GENERAL MOTORS"

replace is cycling through every pattern (part to the left of :) and replaces it with the value (part to the right of :).

replace_regex

version: 1
columns:
  make:
    - input: email
    - replace_regex:
        pattern: "^0$"
        replace: ""