Conversion from character hexadecimal

[#1]

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]

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

Please see e.g. here: http://en.wikipedia.org/wiki/ASCII.

It's decimal representation is 26.

Hope this helps,

Stefan

[#3]

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]

1A hexadecimal is 26 decimal.

So maybe

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

?

[Miguel_Angel_Baeyens]

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.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#6]

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