HugeClob data rendering in spotfire

Hi ,

 

I have a column with HugeClob as data type and it contains some  RTF content.I want to convert it to normal text and display in the report.Is it possible to do it in spotfire?

sample data:

 

{\rtf1\ansi\ansicpg1252\uc1\deff1{\fonttbl
{\f0\fswiss\fcharset0\fprq2 Arial;}
{\f1\froman\fcharset0\fprq2 Times New Roman;}
{\f2\froman\fcharset2\fprq2 Symbol;}}
{\colortbl;\red0\green0\blue0;\red255\green255\blue255;}
{\stylesheet{\s0\itap0\nowidctlpar\f1\fs24 Normal;}{\*\cs10\additive Default Paragraph Font;}{\s16\itap0\nowidctlpar\f0\fs24 [Normal];}}
{\*\generator TX_RTF32 13.0.501.502;}
\deftab1134\paperw5674\paperh12010\margl0\margt0\margr0\margb0\widowctrl
{\*\background{\shp{\*\shpinst\shpleft0\shptop0\shpright0\shpbottom0\shpfhdr0\shpbxmargin\shpbxignore\shpbymargin\shpbyignore\shpwr0\shpwrk0\shpfblwtxt1\shplid1025{\sp{\sn shapeType}{\sv 1}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn fillColor}{\sv 16777215}}{\sp{\sn fFilled}{\sv 1}}{\sp{\sn lineWidth}{\sv 0}}{\sp{\sn fLine}{\sv 0}}{\sp{\sn fBackground}{\sv 1}}{\sp{\sn fLayoutInCell}{\sv 1}}}}}\pard\s16\itap0\nowidctlpar\plain\f1\fs20 During the CRO report audit of JKA00298, an inconsistency was noticed within the report sections.  Report page viii, indicates concentration of JNJ-26489112 was 105.5% of target, however, the CRL PI Report for Dose Analysis on pages 128 and 155 indicate 105.4% of target.\par\par }

Any help will be highly appreciated.

Login