# Help with querying text fields that contain decimal values, ie 2000 = 2000.00

**URL:** <https://discuss.elastic.co/t/help-with-querying-text-fields-that-contain-decimal-values-ie-2000-2000-00/256547>\
**Category:** Elastic Search\
**Tags:** elastic-app-search\
**Created:** [November 24, 2020, 5:09pm UTC](https://discuss.elastic.co/t/help-with-querying-text-fields-that-contain-decimal-values-ie-2000-2000-00/256547 "2020-11-24T17:09:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![DaveRowley](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DaveRowley](https://discuss.elastic.co/u/DaveRowley)\
**Post date:** [November 24, 2020, 5:09pm UTC](https://discuss.elastic.co/t/help-with-querying-text-fields-that-contain-decimal-values-ie-2000-2000-00/256547/1 "2020-11-24T17:09:11Z")

</div>

Hello, I'm having difficulty trying to find decimal values in a text field without specifying the decimal part. I'd like a query for '2000' to also include results from fields that contain '2000.00', and preferably ignore separating commas as well, ie 2000 = 2,000 = 2000.00

The field is mapped as text, with a 'sub field' of .english for language analysis and english stop words.

Any advice or reading material welcome 🙂  
-Dave

---

<div class="post-metadata">

**Author:** ![constancecchen](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/constancecchen/32/71762_2.png) [@constancecchen](https://discuss.elastic.co/u/constancecchen)\
**Post date:** [November 30, 2020, 7:40pm UTC](https://discuss.elastic.co/t/help-with-querying-text-fields-that-contain-decimal-values-ie-2000-2000-00/256547/2 "2020-11-30T19:40:38Z")

</div>

Hey Dave! If this is for App Search, you could try creating a synonym for the strings 2000, 2000.00, and 2,000. Check the below screenshot for an example:

 ![synonyms](https://us1.discourse-cdn.com/elastic/original/3X/5/4/54c811a5c771f19a0d2204d4808e8c2f2993894d.png)

Hope that helps!

---

<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:** [December 28, 2020, 7:40pm UTC](https://discuss.elastic.co/t/help-with-querying-text-fields-that-contain-decimal-values-ie-2000-2000-00/256547/3 "2020-12-28T19:40:40Z")

</div>

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