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
Hi
Try like
...your query...| replace "*%20" with "*" in REGION_CD
| stats count by REGION_CD
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?
Hi
Try like
...your query...| replace "*%20" with "*" in REGION_CD
| stats count by REGION_CD