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

[mrr6892]

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

[to4kawa]

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?

[vnravikumar · Accepted solution]

Hi

Try like

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