Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conversion from character hexadecimal

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

5 Replies
swuehl
MVP
MVP

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

Not applicable

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
MVP
MVP

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

Not applicable

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