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!

Community Content Calendar, November Edition

Welcome to the November edition of our Community Spotlight! Each month, we dive into the Splunk Community to ...

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 ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...