Hello, I'm trying to replace special characters to normal characters in a text file. I've only the HEX-Code of the special characters.
So I have the following example table:
LOAD * INLINE [ field1
The result should be:
Currently I have the following script:
MAPPING LOAD * INLINE [
(Hex)42, \ // Replace '*' with '\'
mapsubstring('Mapping', @1) as field1
FROM D:\xyz.txt (txt, codepage is 1252, no labels, delimiter is '|', msq, no eof);
I assume that (Hex)42 would not be interpreted correctly in mapping tables. The character '*' is only an example to show you the problem. The special characters of the original text file isn't representable. I only know the HEX-Code.