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

[chris_mccann]

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.

[Peter_Cammaert · Accepted solution]

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

[#3]

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);