Example of using Character Substitution in Replicate

[KellyHobson]

Within Replicate Task Settings -> Character Substitution you have the option to substitute or delete source characters.

Note- All characters must be specified as Unicode code points.

Task is a Postgres Source to Snowflake target.

Source:

In the first example,  we replace letter 'X' to 'R'.

Ref: https://www.utf8-chartable.de/

Target output:

In the second example, we delete the letter 'X'.

Target output:

Environment

• Qlik Replicate 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.