Splunk Search

How do you format a table row as currency but not the column field only a specific row?

EmEdwards
Path Finder

I have a table that has various columns of Totals. However, the CurrentYear can represent different information.

I only want to Format the row Category = Money as a currency value = £100000

EG

Category                          CurrentYear
Money                              100000
Cases                                    10
Visits                                     20

I'm unsure how to format a row without formatting the entire column of CurrentYear.

thanks

Tags (3)
0 Karma
1 Solution

renjith_nair
SplunkTrust
SplunkTrust

@EmEdwards,

Does this help?

|eval CurrentYear=if(Category=="Money","£".CurrentYear,CurrentYear)

You may add "£".tostring(CurrentYear,"commas") as well

Happy Splunking!

View solution in original post

0 Karma

renjith_nair
SplunkTrust
SplunkTrust

@EmEdwards,

Does this help?

|eval CurrentYear=if(Category=="Money","£".CurrentYear,CurrentYear)

You may add "£".tostring(CurrentYear,"commas") as well

Happy Splunking!
0 Karma
Get Updates on the Splunk Community!

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...