Splunk Search

How to separate search results?

ba_nathan
New Member

Hi all,

My search results are formatted similar to that of HTML, eg:

<last_modified_date>1669004771000</last_modified_date><assigned_group>Test Group 1</assigned_group><assigned_support_company>Company 1</assigned_support_company><assigned_support_organization>Analytics</assigned_support_organization><assignee>John Doe</assignee>

I would like to split these results including their headings in <>

I have tried rex and other commands, but am stuck

Labels (1)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @ba_nathan,

did you tried this regex:

\<last_modified_date\>(?<last_modified_date>[^\>]*)\>\<assigned_group\>(?<assigned_group>[^\>]*)\>\<assigned_support_company\>(?<assigned_support_company>[^\>]*)\>\<assigned_support_organization\>(?<assigned_support_organization>[^\>]*)\>\<assignee\>(?<assignee>[^\>]*)\>

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

Ciao.

Giuseppe

0 Karma
Get Updates on the Splunk Community!

Splunk Search APIを使えば調査過程が残せます

   このゲストブログは、JCOM株式会社の情報セキュリティ本部・専任部長である渡辺慎太郎氏によって執筆されました。 Note: This article is published in both Japanese ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...