Character-wise translate string

Supported in: Batch, Streaming

Replaces individual characters from the input column that are found in the matching with the corresponding character in the replacement string. If the matching string is longer than the replacement string, characters at the end of the matching string will be dropped.

Expression categories: String

Declared arguments

• Expression - Expression to translate.
  Expression<AnyType>
• Matching string - String containing characters that match the input string.
  Literal<String>
• Replacement string - String containing characters to replace matching characters.
  Literal<String>

Output type: String

Examples

Example 1: Base case

Argument values:

• Expression: translate
• Matching string: rnlt
• Replacement string: 123

Output: 1a2s3ae

---

Example 2: Base case

Argument values:

• Expression: abc
• Matching string: aab
• Replacement string: de

Output: dc

---

Example 3: Base case

Argument values:

• Expression: abc
• Matching string: acb
• Replacement string: de

Output: de

---

Example 4: Base case

Argument values:

• Expression: abc
• Matching string: ac
• Replacement string: df

Output: dbf

---

Example 5: Null case

Argument values:

• Expression: null
• Matching string: a
• Replacement string: b

Output: null

---