Splunk Search

How to edit my search to extract the last appended letter in a URI field and use eval to assign each letter a certain value?

rsingh_splunk
Splunk Employee
Splunk Employee

Hi all,

I need to extract the last appended letter part in the URI field and use eval to term them as:
d = Detail
m = Hover
e = Edit
o = Home Page

My data below consists of this format "/15_digit_alphanumeric/Flag_I_need"
/ab0/o
/ab040000001BUXp
/ab03300000Fsmcs/e
/ab03300000EZAwx/m
/ab03300000Ejhtx/d

My current search is:

EVENT_TYPE=URI  URI=/ab0* | eval description=case(match(URI,"/ab0/o"),"Home Page", match(URI,"/ab0[a-zA-Z0-9]{12}"),"List Page", match(URI,"/ab0[a-zA-Z0-9]{12}/e"),"Edit Page",match(URI,"/ab0[a-zA-Z0-9]{12}/m"),"Hover") |...

But it only shows the "Home Page" correctly and shows all the other description value as "List Page".
Any help would be greatly appreciated, Thanks in advance.

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Change the order of the entries in your case statement so "List Page" is last. It's the more general regex so the Edit Page and Hover entries don't get past it.

---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

Change the order of the entries in your case statement so "List Page" is last. It's the more general regex so the Edit Page and Hover entries don't get past it.

---
If this reply helps you, Karma would be appreciated.

rsingh_splunk
Splunk Employee
Splunk Employee

ah! that's how it works.
Thanks richgalloway , works like charm now.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI! Discover how Splunk’s agentic AI ...

[Puzzles] Solve, Learn, Repeat: Dereferencing XML to Fixed-length events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Stay Connected: Your Guide to December Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...