Getting Data In

How to extract all children in xml?

matstap
Communicator

I have part of an xml file which looks like this:

<Field name="Name1" type="string" length="16">
    <Comments>
        <p/>Value 1
    </Comments>
</Field>
<Field name="Name2" type="string" length="8">
    <Comments>
        <p/>Value 2:
        <ul>
           <li>Value 2a</li>
           <li>Value 2b</li>
        </ul>
    </Comments>

I am trying to make a field called Comments with all the text inside the Comments tag for each Field tag.
Example:
For Name1, Comments="Value 1"
For Name2, Comments="Value 2: Value 2a Value2b

In the case of Name2, how do I capture the list as well as the paragraph?

I have tried spath path=...Field.Comments but that only captures the <p> .

0 Karma
1 Solution

clara-fication
Super Champion

have you tried xpath instead?

https://docs.splunk.com/Documentation/SplunkCloud/6.6.3/SearchReference/Xpath

it still might be tricky to get all of them under comments, but what if you just tried |xpath outfield=Comments "//Field/Comments"

Solution Clara-fied!

View solution in original post

0 Karma

clara-fication
Super Champion

have you tried xpath instead?

https://docs.splunk.com/Documentation/SplunkCloud/6.6.3/SearchReference/Xpath

it still might be tricky to get all of them under comments, but what if you just tried |xpath outfield=Comments "//Field/Comments"

Solution Clara-fied!
0 Karma

matstap
Communicator

Thanks. That worked to capture everything inside the Comments. I then removed the tags to get my desired result: | rex field=Comments mode=sed "s/\<((\w|\/)+)\>//g"

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Persistent Queue at TcpOut — One of Splunk's Most Practical Features

Splunk introduced persistent queueing at the tcpout layer as one of the most practical resilience features in ...

Build resilience for the agentic era: Join us at Splunk Go San Jose

AI is changing how organizations build, operate, and secure digital services. As teams adopt AI agents and ...

Manage Edge Processor pipelines end to end with APIs

This guide uses the Data Management APIs to create an Edge Processor, onboard one instance, deploy a pipeline ...