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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...