Is it possible to sort multi value field by word length?

[jawahir007]

is it possible to sort multi-value field by word length...if yes then how to.

[gaurav_maniar]

Hi,
append the below code to your query,
If you want calculate the length of entire multi value field and than sort
...| eval mv_length = len(mv_field) | sort mv_length | fields - mv_length | ...

If you want to calculate the length of each value in multi-value field,
...| mvexpand mv_field | eval length = len(mv_field) | mvcombine mv_field delim="," | sort length |...

accept the answer if it helps.

[becksyboy]

This alternative worked for me. Where I wanted to expand a multivalue field, show the length and search for one above a certain length value:

| mvexpand Logon_ID | eval length = len(Logon_ID)| search length >5