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

[fere]

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.

[fere]

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

[fere]

No, not really.

[martin_mueller]

Are you possibly looking for this?

... | eval loc=mvindex(locale, -1)