is it possible to sort multi-value field by word length...if yes then how to.
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.
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