Query Kibana for strings WITHOUT commas?

Elastic Stack Kibana
1

Hi all,

I have a field on Kibana that has long text string values. Sometimes, these values contain commas and sometimes they do not. I want to search on Kibana for any of these values that DO NOT contain commas in the string. Nothing I am trying is working. How can search for only the values without commas?
E.g.
document 1:
"message" => "hello hello 123"
document 2:
"message" => "hello, hello 123"

The query should only return document 2, because the message value contains a comma.

2

In Kibana, you can use the NOT operator combined with a wildcard query to find documents where a specific field does not contain a comma. Here's how you can do it:

  1. Open the Kibana Discover interface.
  2. In the search bar, use the following query:
NOT message:*,

Let me know if it works.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.