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!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...