Dynamically sort field by specific order?

[boxmetal]

Hi Splunk community,

I have an excel file that sorts a field at certain order and possibly changes over time
The excel file look something like this
field1
AS
AC
RO
BE
..

Is it possible for me to sort with that particular field order in a search ? Thanks for your help.

[gcusello · Accepted solution]

Hi @boxmetal,

have you seen the sort command (https://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Sort)?

<your_search>
| sort field1

Ciao.

Giuseppe