Splunk Search

How to map the field values in a table column to a different string?

shrey12
Explorer

A search gives me the following output in the form of a table. For every field value in the Field column, there is a battery power number. I want to map the field value to a string.

Field PowerNumber(Average)
1 &nbsp &nbsp &nbsp 456
2 &nbsp &nbsp &nbsp 42
3 &nbsp &nbsp &nbsp 22
4 &nbsp &nbsp &nbsp 63
5 &nbsp &nbsp &nbsp 63
6 &nbsp &nbsp &nbsp 89

i want to rename the values in the first column to

Field PowerNumber(Average)
ac &nbsp &nbsp &nbsp 456
bc &nbsp &nbsp &nbsp 42
hh &nbsp &nbsp &nbsp 22
gg &nbsp &nbsp &nbsp 63
yt &nbsp &nbsp &nbsp 63
gf &nbsp &nbsp &nbsp 89

Tags (2)
1 Solution

m4him7
Path Finder

shrey12
Explorer

yes thank you so much

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...