topic Re: Wildcard eval to divide multiple values with a constant number like 2 in Splunk Search https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107574#M27957 <P>By doing *Street, I can get all timechart of all the fields ending with "Street" for e.g. BrooklynStreet,WestStreet,etc.</P> Fri, 01 Feb 2013 10:00:18 GMT batcave 2013-02-01T10:00:18Z Wildcard eval to divide multiple values with a constant number like 2 https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107572#M27955 <P>I have a search which gets timings across many Streets. But these times are in seconds and I want to convert to minutes. Is there a way to wildcard eval all these values?</P> <P>e.g. </P> <PRE><CODE>timechart perc95(*Street) AS *Street -- &gt; values are in seconds </CODE></PRE> <P>I want something in minutes like this:</P> <P>e.g. </P> <PRE><CODE>timechart perc95(*Street)/60 AS *Street --&gt; Ofcourse this doesnt work but you get the idea I think. </CODE></PRE> Fri, 01 Feb 2013 05:59:57 GMT https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107572#M27955 batcave 2013-02-01T05:59:57Z Re: Wildcard eval to divide multiple values with a constant number like 2 https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107573#M27956 <P>Just to clarify, there are wildcards hidden in the formatting, right?</P> <PRE><CODE>timechart perc95(*Street) AS *Street </CODE></PRE> Fri, 01 Feb 2013 07:50:45 GMT https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107573#M27956 martin_mueller 2013-02-01T07:50:45Z Re: Wildcard eval to divide multiple values with a constant number like 2 https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107574#M27957 <P>By doing *Street, I can get all timechart of all the fields ending with "Street" for e.g. BrooklynStreet,WestStreet,etc.</P> Fri, 01 Feb 2013 10:00:18 GMT https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107574#M27957 batcave 2013-02-01T10:00:18Z Re: Wildcard eval to divide multiple values with a constant number like 2 https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107575#M27958 <P>anyone have an answer to this? anyone from Splunk?</P> Mon, 04 Feb 2013 04:31:40 GMT https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107575#M27958 batcave 2013-02-04T04:31:40Z Re: Wildcard eval to divide multiple values with a constant number like 2 https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107576#M27959 <P>eval doesn't do wildcards, they get confused with the multiplication sign.</P> Mon, 04 Feb 2013 06:43:45 GMT https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107576#M27959 martin_mueller 2013-02-04T06:43:45Z Re: Wildcard eval to divide multiple values with a constant number like 2 https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107577#M27960 <P>yep true. that's why searching for a way to do it alternatively</P> Tue, 05 Feb 2013 01:56:47 GMT https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107577#M27960 batcave 2013-02-05T01:56:47Z Re: Wildcard eval to divide multiple values with a constant number like 2 https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107578#M27961 <P>My boss has allowed me some time to build a wildcard-capable scaling command <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 05 Feb 2013 08:07:18 GMT https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107578#M27961 martin_mueller 2013-02-05T08:07:18Z Re: Wildcard eval to divide multiple values with a constant number like 2 https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107579#M27962 <P>Give this a try: <A href="http://splunk-base.splunk.com/apps/76026/scale-command">http://splunk-base.splunk.com/apps/76026/scale-command</A></P> Fri, 15 Feb 2013 18:04:59 GMT https://community.splunk.com/t5/Splunk-Search/Wildcard-eval-to-divide-multiple-values-with-a-constant-number/m-p/107579#M27962 martin_mueller 2013-02-15T18:04:59Z