Filter out short strings

Elastic Stack Kibana
1

When I create a data table to visualize top terms by count, I want to exclude strings that are <4 characters.

Visualization, +, Data Table
select index
Metrics: default Count
Buckets: Split Rows, Aggregation: Terms, Field, SearchTerms, Order By metric: Count, Order Descend, Size 5

Now I want to hide SearchTerms with string length <4. The SearchTerms are from a split{} in a mutate plugin, so I can't easily create the length using the ruby plugin.

How can I do this?

Thanks for your help.

2

After some searching, I found the easiest way is to:

  1. click Advanced
  2. In "Exclude" field use "Regular Expression Syntax" (https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-regexp-query.html#regexp-syntax)

Example: to exclude strings with less that 4 characters, the Exclude value would be
.{1,3}

3

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