# Remove commas from number field

**URL:** <https://discuss.elastic.co/t/remove-commas-from-number-field/204380>\
**Category:** Kibana\
**Created:** [October 20, 2019, 9:08pm UTC](https://discuss.elastic.co/t/remove-commas-from-number-field/204380 "2019-10-20T21:08:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sud0](https://avatars.discourse-cdn.com/v4/letter/s/e5b9ba/32.png) [@sud0](https://discuss.elastic.co/u/sud0)\
**Post date:** [October 20, 2019, 9:08pm UTC](https://discuss.elastic.co/t/remove-commas-from-number-field/204380/1 "2019-10-20T21:08:59Z")

</div>

Hi guys.

I am filtering customer id using the below:

`(%{NUMBER:customer-id:int}`

On my Kibana dashboard, I see it with `,` and I would like to take the commas out.

Example:

` **#** customer-id 389,542,059`

Expected:

` **#** customer-id 389542059`

I did some changes to the `Filter field format` but I couldn't find the correct pattern.

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [October 20, 2019, 11:17pm UTC](https://discuss.elastic.co/t/remove-commas-from-number-field/204380/2 "2019-10-20T23:17:11Z")

</div>

Hi @sud0 what kind of visualization are you using on the dashboard?

Have you look at the [advanced settings](https://www.elastic.co/guide/en/kibana/current/advanced-options.html)

Specifically `format:number:defaultPattern` but that will change it for all numbers.

Also you could keep the `customer-id` as a `text` and / or `keyword` data type if you are not planning to do any arithmetic with the number instead of making it an integer.

---

<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:** [November 17, 2019, 11:17pm UTC](https://discuss.elastic.co/t/remove-commas-from-number-field/204380/3 "2019-11-17T23:17:13Z")

</div>

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