topic Conversion from character hexadecimal in QlikView

Conversion from character hexadecimal

Wed, 19 Oct 2011 15:24:04 GMT

Hi all,

Can someone tell me how can I replace the character in hexadecimal format "1A" with the function Repalce (Field, chr (???), chr (32))?

What is the character "1A"?

Where can I find a conversion table?

Thank

swuehl — Wed, 19 Oct 2011 15:33:30 GMT

ASCII character 0x1A is the SUB (substitute) character.

It's decimal representation is 26.

Hope this helps,

Stefan

Wed, 19 Oct 2011 15:42:01 GMT

Thank Swuehl,

but if I have a character 1A (in hexadecimal) in a text files, how can I transform it with the replace function?

Ex: replace (Field1, chr(???),chr(32))

Thank

swuehl — Wed, 19 Oct 2011 16:02:37 GMT

1A hexadecimal is 26 decimal.

So maybe

replace (Field1, chr(26), chr(32))

Miguel_Angel_Baeyens — Wed, 19 Oct 2011 19:14:50 GMT

Hi,

If you can get different hex / ascii codes, you may use the following instead

=Replace('A1AB1AC', Num#('1A', '(R16)'), ' ')

1A is the code and R16 the base (HEX will do as well). QlikView supports conversions between base 2 and 32. The above returns

A B C

Hope that helps.

BI Consultant

Tue, 25 Oct 2011 12:22:50 GMT

Hi Miguel,

I did not understand your answer.

When reading the file, find the characters "1A", it stops to read believing at the end of file.

I solved the problem by reading the file with the option ignores EOF.

Thank 1000