Splunk Search

Translate and overwrite the values of a field

akr
Loves-to-Learn Lots

I am new to Splunk. I am trying to overwrite the values of a field (eventLevel) that is in Japanese. I created a lookup table to convert these values to English so that the data is more readable. Now, how can I see those translated values in the eventLevel field?

Labels (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

You could do something like this (this assumes you have at least two fields in your lookup, one called eventlevel (to match your event field) and the other call english_eventlevel)

| lookup translator.csv eventlevel OUTPUT english_eventlevel
| eval eventlevel = coalesce(english_eventlevel, eventlevel)

The coalesce ensures that if there isn't a translation, you keep the original eventlevel

0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...