Hello, I have a URL that has XML structure and would like to get also the child elements for a particular field. In the example below, I would like to get the from structure as a field so that I can filter on the values. Tove Jani Reminder Don't forget me this weekend! My table structure should be as follows,note to from heading bodyAt the moment, I am only getting note field with a message "the cell has trailing spaces and embedded newlines"thanks, XMLParse.PNG parse tool.PNG

Deriving XML child elements from URL

Hello,

I have a URL that has XML structure and would like to get also the child elements for a particular field.

In the example below, I would like to get the from structure as a field so that I can filter on the values.

<note>

<from>Jani</from>

<heading>Reminder</heading>

<body>Don't forget me this weekend!</body>

</note>

My table structure should be as follows,

note to from heading body

At the moment, I am only getting note field with a message "the cell has trailing spaces and embedded newlines"

thanks,

Parse

Hi,

I got it to work by parsing multiple XML parser by checking return outer XML each time.

One way of doing this.

Input was:

Many thanks

Shanker V

Hi,

thanks for your input.

It doesn't help me as I would like to split it to columns. I have chosen split to columns but it gives empty values.

thanks

Hi,

I got it to work by parsing multiple XML parser by checking return outer XML each time.