Getting Data In

Pivot FILTER exclude quotation mark character

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
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!