Skip to main content Skip to complementary content
Qlik Resources
Announcements

Character substitution

You can substitute or delete source characters in the target database and/or you can substitute or delete source characters that are not supported by a selected character set.

Information note

  • All characters must be specified as Unicode code points.

  • Character substitution will also be performed on Replicate Control Tables.

  • Invalid values will be indicated by a red triangle in the top right of the table cell. Hovering your mouse cursor over the triangle will show the error message.

  • Any table-level or global transformations defined for the task will be performed after the character substitution has been completed.

  • Substitutions actions defined in the Substitute or Delete Source Characters table are performed before the substitution action defined in the Substitute or Delete Source Characters Unsupported by the Selected Character Set table.

  • Character substitution does not support LOB data types.

Substituting or deleting Source Characters

Use the Substitute or Delete Source Characters table to define replacements for specific source characters. This may be useful, for example, when the Unicode representation of a character is different on the source and target platforms. For example, on Linux, the minus character in the Shift_JIS character set is represented as U+2212, but on Windows it is represented as U+FF0D.

Substitution actions
To Do This

Define substitution actions.

  1. Click the Add Character button above the table.

  2. Specify a source character and a target character in the Source Character and Substitute Character fields respectively.

    For example to replace the letter "a" with the letter "e", specify 0061 and 0065 respectively.

    Information note

    To delete the specified source character, enter 0 in the Substitute Character column.

  3. Repeat steps 1-2 to replace or delete additional characters.

Edit the specified source or target character

Click anywhere in the relevant column and change the character as required.

Delete entries from the table

Select the desired entry or entries and click the Delete button.

Substituting or deleting Source Characters unsupported by the selected character set

Use the Substitute or Delete Source Characters Unsupported by the Selected Character Set table to define a single replacement character for all characters not supported by the selected character set.

Unsupported character substitution actions
To Do This

Define or edit a substitution action.

  1. Select a character set from the Character Set drop-down list in the table.

    Any characters not supported by the selected character set will be replaced on the target by the character specified in step 2 below.

  2. In the Substitute Character column, click anywhere in the column and specify the replacement character. For example, to replace all unsupported characters with the letter "a", enter 0061.

    Information note

    To delete all unsupported characters, enter 0.

Disable the substitution action.

Select the blank entry from the Character Set drop-down list.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here