topic Display RTF content from a BLOB in QlikView

Display RTF content from a BLOB

Mon, 21 Jun 2010 16:22:56 GMT

When I load a RTF from a BLOB field from our database, the RTF display unformatted (it displays all the RTF coding including the text). When I copy the displayed text to a txt file and rename it to a RTF, it displays fine in word. So the format coding is correct.

How can I correctly display the RTF content?

This is the script I use:

ata:

Load *,
GDTXKY as TXTKEY;

SELECT
GDTXKY,
GDMUSE

FROM "JDE_VHSPY".CRPDTA.F00165 where GDTXKY like '%|prod_order';

Blob:

INFO Load

GDTXKY as TXTKEY,
GDTXVC as TXT;

bundle INFO SELECT
GDTXKY,
GDTXVC

FROM "JDE_VHSPY".CRPDTA.F00165 where GDTXKY like '%|prod_order'

How can I correctly display the RTF content?

Display RTF content from a BLOB

dpietersz — Fri, 09 Jul 2010 14:23:27 GMT

Hi Did you find a solution for this?

I have a similar problem for viewing pdf

Display RTF content from a BLOB

Tue, 13 Jul 2010 09:45:36 GMT

I have the simular problem, i must print formated Text (RTF or HTML).

Have you a solution for this Problem ?

Thx

Display RTF content from a BLOB

Thu, 29 Mar 2012 14:49:39 GMT

Well the answer is there, It is not supported

QlikView does not support/interpret rtf format and therefore this won't work straight out of the box. There is no generic solution for this so you would need to convert the rtf file to a txt file before you import it into QlikView.

Kind regards,

QlikView Support