Splunk Search

How to merge a row count in a table to other row

Loves-to-Learn

Hi,

I am trying to merge below row "EUR%20" count to "EUR" . Please help.

String:

sourcetype=access_combined index="web_technology" host="*" clientip="*" REGION_CD!=ALL REGION_CD!=ALL%20 | stats count by REGION_CD

alt text

0 Karma
1 Solution

Champion

Hi

Try like

...your query...| replace "*%20" with "*" in REGION_CD 
| stats count by REGION_CD

View solution in original post

0 Karma

Ultra Champion
sourcetype=access_combined index="web_technology" host="" clientip="" 
| eval REGION_CD=trim(urldecode(REGION_CD))
| stats count by REGION_CD
| where REGION_CD!="ALL"

Hi, how about this?

0 Karma

Champion

Hi

Try like

...your query...| replace "*%20" with "*" in REGION_CD 
| stats count by REGION_CD

View solution in original post

0 Karma