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.
... View more