XML output adding CDATA to string

[veryimportantdude]

Hello.

I have to create an XML from my DB data and the specifications reguest adding <!CDATA[]]> to all string tags.

<item>

<ID><9191</ID>

<name><![CDATA[random text 2]]></name>

<price>19,9</price>

<store><![CDATA[Ankaranska cesta xx, 6000 Koper]]></store>

</item>

<ID><111</ID>

<name><![CDATA[VRandom text]]></name>

<price>99,9</price>

<store><![CDATA[Road to nowhere xx, 6000 Koper]]></store>

<item>

</item>

I found only a post where I do a find replace, but that will take quite a lot of time and also later debug might be tough.

https://community.talend.com/s/question/0D53p00008BbGq7CAF/adding-tag-cdata-to-xml?language=en_US

any suggestions on a work around?

thank you

[Anonymous]

Hello,

So far, I'm not sure there is another way to Shong's way though (Using tReplace solution).

Best regards

Sabrina

[Amanda2569]

Thanks for sharing. I found a lot of interesting information here.

AlaskasWorld PET