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!

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer at Splunk .conf24 ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

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

Combine Multiline Logs into a Single Event with SOCK: a Step-by-Step Guide for ...

Combine multiline logs into a single event with SOCK - a step-by-step guide for newbies Olga Malita The ...