Character mapping hexadecimal

[#1]

Hello,

I have the following script:

mapping_table:

MAPPING LOAD * INLINE [

x,y

(HEX)DEBB, ö

...

];

table1:

LOAD @1 as name

FROM [file.txt] (txt, ansi, codepage is 1252, no labels, delimiter is '|', msq);

Now I would like to map the field 'name' to replace some serious characters:

table2:

LOAD mapsubstring('mapping_table', name) as nameNew

RESIDENT table1;

To avoid failures through interpreting by qlikview a hexadecimal value is necessary. In the end the serious characters should be shown as ä,ö,ü,ß, ...

Can anyone help me to replace the characters?

[swuehl]

Could you provide a sample text file that you want to load and map?

[#3]

Sry, this is currently not possible.

The txt.file was copied from a unix / z/os system to a windows system, so there is a problem with the utf-8 standard. The characters ä, ö, ü are displayed very serious.

Changing 'ansi' to 'utf-8' or 'oem' in the load script doesn't fix the problem.

[#4]

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:

Table1:

LOAD * INLINE [ field1

abc*356,

dsfsdf*45$6 ];

The result should be:

abc\356,

dsfsdf\45$6

Currently I have the following script:

Mapping:

MAPPING LOAD * INLINE [

x, y

(Hex)42, \      // Replace '*' with '\'

];

table2:

LOAD

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.