# Apply text analysis on a field

**URL:** <https://discuss.elastic.co/t/apply-text-analysis-on-a-field/146137>\
**Category:** Elasticsearch\
**Created:** [August 27, 2018, 9:20am UTC](https://discuss.elastic.co/t/apply-text-analysis-on-a-field/146137 "2018-08-27T09:20:15Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![M.alsioufi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/m.alsioufi/32/52269_2.png) [@M.alsioufi](https://discuss.elastic.co/u/M.alsioufi)\
**Post date:** [August 27, 2018, 9:20am UTC](https://discuss.elastic.co/t/apply-text-analysis-on-a-field/146137/1 "2018-08-27T09:20:15Z")

</div>

I have a field of type `text` let's call it `my_field` . This field contains comma separated values, sometimes these values can repeat many times for example : 'sun' or 'sun,cloud' or 'sun,sun,sun,cloud' or 'sun,cloud,wind,sun,wind,sun' etc.. what I am willing to do is to enable the users to search for documents where this field for example has the word sun three times or has the word cloud only one time and so on. Is there a way to do this with text analysis in elasticsearch, scripted fields, `regexp` query with{}...etc?

I want to do this search using Kibana search bar and I am using Elasticsearch/Kibana v6.3.2

---

<div class="post-metadata">

**Author:** ![Niclas\_Popp\_BPS](https://avatars.discourse-cdn.com/v4/letter/n/f6c823/32.png) [@Niclas\_Popp\_BPS](https://discuss.elastic.co/u/Niclas_Popp_BPS)\
**Post date:** [August 27, 2018, 10:02am UTC](https://discuss.elastic.co/t/apply-text-analysis-on-a-field/146137/2 "2018-08-27T10:02:03Z")

</div>

You could basically use a wildcard query if I understood correctly

---

<div class="post-metadata">

**Author:** ![M.alsioufi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/m.alsioufi/32/52269_2.png) [@M.alsioufi](https://discuss.elastic.co/u/M.alsioufi)\
**Post date:** [August 27, 2018, 10:49am UTC](https://discuss.elastic.co/t/apply-text-analysis-on-a-field/146137/3 "2018-08-27T10:49:26Z")

</div>

But how can I search for all documents where my\_field value has 3 x for example

---

<div class="post-metadata">

**Author:** ![Niclas\_Popp\_BPS](https://avatars.discourse-cdn.com/v4/letter/n/f6c823/32.png) [@Niclas\_Popp\_BPS](https://discuss.elastic.co/u/Niclas_Popp_BPS)\
**Post date:** [August 27, 2018, 11:23am UTC](https://discuss.elastic.co/t/apply-text-analysis-on-a-field/146137/4 "2018-08-27T11:23:09Z")

</div>

This should do the job:

"query": {  
"wildcard" : { "my\_field" : { "value" : "_x_x_x_", "boost" : 2.0 } }  
}

---

<div class="post-metadata">

**Author:** ![Niclas\_Popp\_BPS](https://avatars.discourse-cdn.com/v4/letter/n/f6c823/32.png) [@Niclas\_Popp\_BPS](https://discuss.elastic.co/u/Niclas_Popp_BPS)\
**Post date:** [August 27, 2018, 11:23am UTC](https://discuss.elastic.co/t/apply-text-analysis-on-a-field/146137/5 "2018-08-27T11:23:54Z")

</div>

Sorry it's : \* x \* x \* x \* in the query

---

<div class="post-metadata">

**Author:** ![M.alsioufi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/m.alsioufi/32/52269_2.png) [@M.alsioufi](https://discuss.elastic.co/u/M.alsioufi)\
**Post date:** [August 27, 2018, 11:45am UTC](https://discuss.elastic.co/t/apply-text-analysis-on-a-field/146137/6 "2018-08-27T11:45:38Z")

</div>

Thanks but this does not answer my question, I want something general, I want to enable the user to use Kibana search bar to search for documents with let's say my\_field's value contains 6 x's (x is just an example it might be a word) RegE query has {} expression but it does not seems to be working as I have followed the example here [https://www.elastic.co/guide/en/elasticsearch/reference/6.3/query-dsl-regexp-query.html](https://www.elastic.co/guide/en/elasticsearch/reference/6.3/query-dsl-regexp-query.html) but it did not work for me ☹ .

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 24, 2018, 11:50am UTC](https://discuss.elastic.co/t/apply-text-analysis-on-a-field/146137/7 "2018-09-24T11:50:44Z")

</div>

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