The current implementation of the Replace transformation gives you two options:
- char replacement: type in the int value of an ascii code and have this replaced by a string
- string replacement: type in a string to be replaced with another string
The interface for the character type replacement is very confusing, as most people will not realise you need to enter an ASCII code until the try to type a character and encounter an error. This type of replacement is apparently used to replace certain control characters - see also here:
I would propose to change the function so you can enter ASCII / Binary / String literals to be replaced by ASCII / Binary / String literals. The REPLACE() function allows for binary input, you should be able to convert to and from ASCII or Unicode code points using SQL functions. Making it easier for users to define the transformation they want.
