# String to full text data table KIBANA

**URL:** <https://discuss.elastic.co/t/string-to-full-text-data-table-kibana/142878>\
**Category:** Kibana\
**Created:** [August 3, 2018, 9:19am UTC](https://discuss.elastic.co/t/string-to-full-text-data-table-kibana/142878 "2018-08-03T09:19:40Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Charaf\_Ahmed](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/charaf_ahmed/32/30467_2.png) [@Charaf\_Ahmed](https://discuss.elastic.co/u/Charaf_Ahmed)\
**Post date:** [August 3, 2018, 9:19am UTC](https://discuss.elastic.co/t/string-to-full-text-data-table-kibana/142878/1 "2018-08-03T09:19:40Z")

</div>

**Example:**  
I have fields`'detail': "totot goes to the market".`

And the idea is to display this sentence (with whites) in a data table.

Currently, the problem I have is that in my data table, whites are ignored and next word is lost.

How could I solve this problem? What kind of "analyze" should you choose?

---

<div class="post-metadata">

**Author:** ![Larry\_Gregory](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/larry_gregory/32/34969_2.png) [@Larry\_Gregory](https://discuss.elastic.co/u/Larry_Gregory)\
**Post date:** [August 3, 2018, 12:40pm UTC](https://discuss.elastic.co/t/string-to-full-text-data-table-kibana/142878/2 "2018-08-03T12:40:46Z")

</div>

Hey @Charaf_Ahmed,

Which analyzer are you using currently? Here's what I see with the standard analyzer:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/e/0edb91c9ff4f267e5647432b4b3a98449bfc4c35.png)

---

<div class="post-metadata">

**Author:** ![Charaf\_Ahmed](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/charaf_ahmed/32/30467_2.png) [@Charaf\_Ahmed](https://discuss.elastic.co/u/Charaf_Ahmed)\
**Post date:** [August 3, 2018, 1:01pm UTC](https://discuss.elastic.co/t/string-to-full-text-data-table-kibana/142878/3 "2018-08-03T13:01:13Z")

</div>

Indeed, that's what I can but I can not do it.

The analysis I use is: whitespace analyze

---

<div class="post-metadata">

**Author:** ![Charaf\_Ahmed](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/charaf_ahmed/32/30467_2.png) [@Charaf\_Ahmed](https://discuss.elastic.co/u/Charaf_Ahmed)\
**Post date:** [August 3, 2018, 1:03pm UTC](https://discuss.elastic.co/t/string-to-full-text-data-table-kibana/142878/4 "2018-08-03T13:03:41Z")

</div>

@Larry_Gregory you advise me to use what to analyze? and why do you have detail.keyword? Keyword? Why ?

---

<div class="post-metadata">

**Author:** ![Larry\_Gregory](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/larry_gregory/32/34969_2.png) [@Larry\_Gregory](https://discuss.elastic.co/u/Larry_Gregory)\
**Post date:** [August 3, 2018, 1:26pm UTC](https://discuss.elastic.co/t/string-to-full-text-data-table-kibana/142878/5 "2018-08-03T13:26:43Z")

</div>

Changing your field from type "text" to type "keyword" will enable you to include your strings within visualizations, such as a data table. Using the keyword type, you will not have to specify a custom analyzer.

If you don't want to use the "keyword" type, then you'll need to create your own [custom analyzer](https://www.elastic.co/guide/en/elasticsearch/reference/current/analyzer.html) to use the ["keyword" tokenizer](https://www.elastic.co/guide/en/elasticsearch/reference/current/analysis-keyword-tokenizer.html)

For more help on that, I'd recommend starting a thread in the Elasticsearch topic

---

<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:** [August 31, 2018, 1:26pm UTC](https://discuss.elastic.co/t/string-to-full-text-data-table-kibana/142878/6 "2018-08-31T13:26:43Z")

</div>

Closed on August 31, 2018, 1:26pm UTC

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