Character substitution task settings

Individual character replacement – Amazon DMS can replace the values of selected characters on the source with specified replacement values of corresponding characters on the target. Use the CharacterReplacements array in CharacterSetSettings to select all source characters having the Unicode code points you specify. Use this array also to specify the replacement code points for the corresponding characters on the target.

To select all characters on the source that have a given code point, set an instance of SourceCharacterCodePoint in the CharacterReplacements array to that code point. Then specify the replacement code point for all equivalent target characters by setting the corresponding instance of TargetCharacterCodePoint in this array. To delete target characters instead of replacing them, set the appropriate instances of TargetCharacterCodePoint to zero (0). You can replace or delete as many different values of target characters as you want by specifying additional pairs of SourceCharacterCodePoint and TargetCharacterCodePoint settings in the CharacterReplacements array. If you specify the same value for multiple instances of SourceCharacterCodePoint, the value of the last corresponding setting of TargetCharacterCodePoint applies on the target.

For example, suppose that you specify the following values for CharacterReplacements.

"CharacterSetSettings": {
    "CharacterReplacements": [ {
        "SourceCharacterCodePoint": 62,
        "TargetCharacterCodePoint": 61
        }, {
        "SourceCharacterCodePoint": 42,
        "TargetCharacterCodePoint": 41
        }
    ]
}

In this example, Amazon DMS replaces all characters with the source code point hex value 62 on the target by characters with the code point value 61. Also, Amazon DMS replaces all characters with the source code point 42 on the target by characters with the code point value 41. In other words, Amazon DMS replaces all instances of the letter 'b'on the target by the letter 'a'. Similarly, Amazon DMS replaces all instances of the letter 'B' on the target by the letter 'A'.

Character set validation and replacement – After any individual character replacements complete, Amazon DMS can make sure that all target characters have valid Unicode code points in the single character set that you specify. You use CharacterSetSupport in CharacterSetSettings to configure this target character verification and modification. To specify the verification character set, set CharacterSet in CharacterSetSupport to the character set's string value. (The possible values for CharacterSet follow.) You can have Amazon DMS modify the invalid target characters in one of the following ways:

For example, suppose that you specify the following values for CharacterSetSupport.

"CharacterSetSettings": {
    "CharacterSetSupport": {
        "CharacterSet": "UTF16_PlatformEndian",
        "ReplaceWithCharacterCodePoint": 0
    }
}

In this example, Amazon DMS deletes any characters found on the target that are invalid in the "UTF16_PlatformEndian" character set. So, any characters specified with the hex value 2FB6 are deleted. This value is invalid because this is a 4-byte Unicode code point and UTF16 character sets accept only characters with 2-byte code points.