Splunk Search

$1234,000 i need to remove strings from value

vareddy
Observer

1000040701.jpg

 but value are not change 

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

It looks like your data values are strings but you are trying to add totals i.e. treating them as numerics. Try removing the commas (as well as the $ signs) and converting the bracketed number to negative e.g. change the "(" to "-" and remove the ")".

0 Karma

PickleRick
SplunkTrust
SplunkTrust

You need to provide us with more info. So far we know that apparently some values did not change even though you thought they would. But what values, what exactly did you do and what result did you expect - that's unknown to us.

And please copy-paste your event data and expected/actual result instead of posting a photo - it's much more convenient to handle for us here.

0 Karma
Get Updates on the Splunk Community!

Building Reliable Asset and Identity Frameworks in Splunk ES

 Accurate asset and identity resolution is the backbone of security operations. Without it, alerts are ...

Cloud Monitoring Console - Unlocking Greater Visibility in SVC Usage Reporting

For Splunk Cloud customers, understanding and optimizing Splunk Virtual Compute (SVC) usage and resource ...

Automatic Discovery Part 3: Practical Use Cases

If you’ve enabled Automatic Discovery in your install of the Splunk Distribution of the OpenTelemetry ...