Splunk Search

Extract string within specific tag

kirangurram
Explorer

Hello Experts ,
Need your assistance to extract output from one of the below XML tags.
I have three XML tags with same naming convention and I want only extract specific value 3 from the below tags.
can you help me to provide rex commend (or) any other commend which will only extract value 3 from the below tags.

<Val Ty="CHAR">Feedback</Val>
<Val Ty="CHAR">3</Val>
<Val Ty="CHAR">TRST</Val>

your help is much appreciated.

Tags (1)
0 Karma
1 Solution

vnravikumar
Champion

Hi

Try this

|makeresults  |eval tag="<Val Ty=\"CHAR\">Feedback</Val>
<Val Ty=\"CHAR\">3</Val>
<Val Ty=\"CHAR\">TRST</Val>" |rex field=tag "CHAR\"\>(?P<output>(\d+))\<"

OR

| makeresults 
| eval tag="<Val Ty=\"CHAR\">Feedback</Val>
 <Val Ty=\"CHAR\">3</Val>
 <Val Ty=\"CHAR\">TRST</Val>" 
| rex field=tag max_match=0 "\"CHAR\">(?P<output>.+)<" 
| eval result = mvindex(output,1)

View solution in original post

0 Karma

kirangurram
Explorer

Thanks @vnravikumar , below solution works.
Second solution didnt give me desired results.

|makeresults |eval tag="Feedback
3
TRST" |rex field=tag "CHAR\">(?P(\d+))<"

0 Karma

vnravikumar
Champion

Hi

Try this

|makeresults  |eval tag="<Val Ty=\"CHAR\">Feedback</Val>
<Val Ty=\"CHAR\">3</Val>
<Val Ty=\"CHAR\">TRST</Val>" |rex field=tag "CHAR\"\>(?P<output>(\d+))\<"

OR

| makeresults 
| eval tag="<Val Ty=\"CHAR\">Feedback</Val>
 <Val Ty=\"CHAR\">3</Val>
 <Val Ty=\"CHAR\">TRST</Val>" 
| rex field=tag max_match=0 "\"CHAR\">(?P<output>.+)<" 
| eval result = mvindex(output,1)
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!

Data Management Digest – September 2026

    Welcome to the September 2026 edition of Data Management Digest! September brought a fresh wave of ...

Federated Search for CloudWatch Unified Data Store Is Generally Available

As organizations modernize their cloud environments, AWS workloads generate more security, operational, and ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...