topic Re: Can RTF (Rich Text Format) data be imported into Qlikview and if so how do you make it presentable? in QlikView

Can RTF (Rich Text Format) data be imported into Qlikview and if so how do you make it presentable?

chris_mccann — Wed, 18 Dec 2013 09:42:36 GMT

Hello,

I have attached a qvd which has two fields.

QuestionDesc and QuestionID.

QuestionDesc is the RTF field.

It seem to have all the formatting, preceding the actual question.

Can qlikview import RTF if so how do i apply all the formatting applied to it before Qlikview extracts it?

Cheers.

Re: Can RTF (Rich Text Format) data be imported into Qlikview and if so how do you make it presentable?

Peter_Cammaert — Wed, 18 Dec 2013 09:56:27 GMT

The simple answer is: NO

AFAIK text in charts can be formatted using elemntary tags (e.g. like <B> for bold) but that feature doesn't exist in text boxes where your QuestionDesc field would end up eventually. See also this recent discussion: Re: Formatting a portion of text in a textbox

And in any case, QlikView isn't RTF-capable, so it seems that even if the program would support text formatting, you're in for a complex conversion either in the load script (arghhh...) or before turning the data into a QVD.

Best,

Peter

Re: Can RTF (Rich Text Format) data be imported into Qlikview and if so how do you make it presentable?

Wed, 18 Dec 2013 13:54:55 GMT

You need to use String functions to cleanse the data. Please find below script for your qvd:

LOAD QuestionID,

QuestionDesc,

Trim(Subfield(SubField(QuestionDesc,'\cf0',2),'}',1)) AS NewDesc

FROM RTF.qvd (qvd);