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!

Observability Unlocked: Kubernetes Monitoring with Splunk Observability Cloud

 Ready to master Kubernetes and cloud monitoring like the pros? Join Splunk’s Growth Engineering team for an ...

Update Your SOAR Apps for Python 3.13: What Community Developers Need to Know

To Community SOAR App Developers - we're reaching out with an important update regarding Python 3.9's ...

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...