Skip to main content
Question

How can I extract XML stored in a CLOB?

  • October 7, 2020
  • 1 reply
  • 22 views

I have a database table. This table has an attribute "TEKST" which contains the XML as a CLOB. My questions is, how can I, with FME, extract the XML from the CLOB so that I can process it like any other XML file?

 

Many thanks in advance! :)

1 reply

kailinatsafe
Safer
Forum|alt.badge.img+21

Hello @aussiepaul​ , have you tried using the XMLFragmenter? It is typically used to parse data into XML fragments, but it may work in this case. The XMLFragmenter behaves very similar to the XML reader, and we have a great XML tutorial series that shows you how to read, process and write XML with FME!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings