Discussion Board for collaboration related to QlikView App Development.
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?
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,
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))
1A hexadecimal is 26 decimal.
replace (Field1, chr(26), chr(32))
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
Comex Grupo Ibérica
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.