Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Parsing XML w/ Scripts?

  1. #1

    Default Parsing XML w/ Scripts?

    Hiyas,

    I have a field which contains an XML blob in it... I would like to extract a sub blob from that field. The "Get data from XML" will delimit all nested values which is not what I am looking for - I would like the inner XML to be left intact...

    I am thinking I could use a scripting component but I am not sure which would be easiest as I do not know what libraries are available in the JS and Java scripting components. Worse case scenario I can use REGEX but, with the right library, it could be easier in one of the other two.

    Do you have any recommendations or can you give me any insight as to what functions might be available to the scripting components?

    Thanks.

    Keith

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    The JavaScript contains E4X with which you can do pretty much anything.

  3. #3

    Default I like it!

    I have to say... thats a pretty hot little util!

    Thanks.

    Keith

  4. #4

    Default Question...

    Is it possible to turn 1 row into multiple rows via the javascript component?

    For example:

    If the XML is

    <data>
    <item>
    <attr>hi</attr>
    </item>
    <item>
    <attr>bye</attr>
    </item>
    </data>

    How do I produce an output row for each item?

    Thanks.

    Keith

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.