Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Cdata xml

  1. #1
    Join Date
    Dec 2013
    Posts
    1

    Default Cdata xml

    Hi

    I am using a Kettle-Spoon version 5.0.1.

    The information that I have stored in an XML document I would like to store in the database. I use the Get Data from XML and everything works fine. But I have a problem with reading text that is stored in CDATA section. How could I read this text in CDATA and save it to database.

    An example of an XML document:

    <document>
    <employee Id="1" Name="Michael" Surname="No"><![CDATA[Some text that i want to save]]>
    </employee>
    <employee ...><![CDATA[Some text that i want to save]]>
    </employee>
    ...
    </document>

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Quote Originally Posted by vzd View Post
    I have a problem with reading text that is stored in CDATA section
    When looping over //employee I can retrieve the text without problems.

    GDFX field settings
    Name:  GDFX.png
Views: 53
Size:  19.8 KB

    GDFX preview
    Name:  Preview.png
Views: 55
Size:  12.5 KB
    So long, and thanks for all the fish.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.