Splunk Search

How can I make mvfind start its search at the last entry of a multivalue field ?

fere
Path Finder

Hi,
I have a search query that creates trans:
......| eval locale=case(tags=="my-world", "my-world:".screen, tags=="community-world", "community-world:".screen , tags=="puzzle","Puzzles:".screen, tags=="store", "", screen="main-menu", "main-menu") | eval locale=if(isnull(locale), event, locale) | sort sessionId -seqx | transaction sessionId connected=t mvlist=t keepevicted=t keeporphans=t | eval loc==mvfind(locale,"[a-z]$")

I am trying to find the last entry in the mvfield locale that has any text (note {tags=="store", "" } in the query causes some local values to be = "" ). Basically I need to grab the value of the last value in the mvfield locale that is <> "".

mvfind(locale,"[a-z]$") applies the $ to the end of each entry which is not what I need.

Appreciate your quick help.

Tags (1)
0 Karma

fere
Path Finder

I got around the issue by building my transaction in the reverse order.

0 Karma

fere
Path Finder

No, not really.

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Are you possibly looking for this?

... | eval loc=mvindex(locale, -1)
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

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