Getting Data In

Pivot FILTER exclude quotation mark character

teknet9
Path Finder

Hello Team,

I do have a pivot:

| pivot xxxxx RootObject count(RootObject) AS "Count of admin_adminsearch_RMD578e1308ec259874c_at_1525123982_13769" SPLITROW User AS User FILTER User doesNotContain 'mmm' SORT 100 User ROWSUMMARY 0 COLSUMMARY 0 SHOWOTHER 1

I am using FILTER command to exclude all usernames which include mmm.
But i need to exclude usernames which include quotation mark character: "

How to do that ?

Thanks,
Michal

Tags (2)
0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...