Solved: display specific content from message - Splunk Community

Dashboards & Visualizations

I have a below message. how can I only display ResponseID in output? thanks

message: <?xml version='1.0' encoding='ISO-8859-1'?><Submission Id="12345" <LastName>XXX</LastName><ResponseID>137ce83fe8ddb052-1698535326634</ResponseID><Date>2023.10.28 23:23:14</Date>

1 Solution

Solution

you have to use a regex to extract this field, something like this:

index=your_index
| rex "\<ResponseID\>(?<ResponseID>[^\<]*)"
| table _time ResponseID

that you can test at https://regex101.com/r/Sj8hDe/1

Ciao.

Giuseppe

View solution in original post

Solution

you have to use a regex to extract this field, something like this:

index=your_index
| rex "\<ResponseID\>(?<ResponseID>[^\<]*)"
| table _time ResponseID

that you can test at https://regex101.com/r/Sj8hDe/1

Ciao.

Giuseppe

good for you, see next time!

Ciao and happy splunking

Giuseppe

P.S.: Karma Points are appreciated 😉

Get Updates on the Splunk Community!

Enter the Dashboard Challenge and Watch the .conf24 Global Broadcast!

The Splunk Community Dashboard Challenge is still happening, and it's not too late to enter for the week of ...

Join Us at the Builder Bar at .conf24 – Empowering Innovation and Collaboration

What is the Builder Bar? The Builder Bar is more than just a place; it's a hub of creativity, collaboration, ...

Combine Multiline Logs into a Single Event with SOCK - a Guide for Advanced Users

This article is the continuation of the “Combine multiline logs into a single event with SOCK - a step-by-step ...