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!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...