# European number format not recognised

**URL:** <https://discuss.elastic.co/t/european-number-format-not-recognised/292606>\
**Category:** Kibana\
**Created:** [December 21, 2021, 7:37pm UTC](https://discuss.elastic.co/t/european-number-format-not-recognised/292606 "2021-12-21T19:37:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mpmass](https://avatars.discourse-cdn.com/v4/letter/m/ba9def/32.png) [@mpmass](https://discuss.elastic.co/u/mpmass)\
**Post date:** [December 21, 2021, 7:37pm UTC](https://discuss.elastic.co/t/european-number-format-not-recognised/292606/1 "2021-12-21T19:37:26Z")

</div>

Hi,  
I have just started exploring Elastic and Kibana. When I am trying to upload a .csv file, the type and format isn't recognised properly. It is seen as a string instead of a double. The format of the number of the field is European, e.g. the "," is used for the decimal places; 12,33 for example (instead of 12.33). When I change all the comma's to dots then it is recognised as a double. However, I would assume that I can adjust the settings in the "mappings", and "ingest pipeline" so that I do not have to convert the csv file before uploading and we can use the comma instead of the dot.I cannot find any examples how I can do this.

---

<div class="post-metadata">

**Author:** ![dosant](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dosant/32/64489_2.png) [@dosant](https://discuss.elastic.co/u/dosant)\
**Post date:** [December 22, 2021, 10:50am UTC](https://discuss.elastic.co/t/european-number-format-not-recognised/292606/2 "2021-12-22T10:50:11Z")

</div>

Hi @mpmass,

> I would assume that I can adjust the settings in the "mappings", and "ingest pipeline"

Right!  
In mappings, you can change your field from type: "keyword" to type: "double"

and in "ingest pipeline" you can use [gsub](https://www.elastic.co/guide/en/elasticsearch/reference/7.0/gsub-processor.html) processor to replace `,` -\> `.` before processing.

For example, add to processors array:

```auto
{
  "gsub": {
    "field": "your_dobule_field",
    "pattern": ",",
    "replacement": "."
    }
}

```

> **[Import CSV and Log Data into Elasticsearch from Kibana with File Data Visualizer](https://www.elastic.co/blog/importing-csv-and-log-data-into-elasticsearch-with-file-data-visualizer)**
>
> With the File Data Visualizer, it's never been easier to import CSV, NDJSON, and semi-structured text (like log files) into Elasticsearch directly from Kibana.

> **[Gsub Processor | Elasticsearch Guide \[7.0\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/7.0/gsub-processor.html)**

---

<div class="post-metadata">

**Author:** ![mpmass](https://avatars.discourse-cdn.com/v4/letter/m/ba9def/32.png) [@mpmass](https://discuss.elastic.co/u/mpmass)\
**Post date:** [December 22, 2021, 11:41am UTC](https://discuss.elastic.co/t/european-number-format-not-recognised/292606/3 "2021-12-22T11:41:28Z")

</div>

Thanks @dosant. For my understanding, this means I am replacing the comma with a dot, effectively the string is transformed to the US format. What if I still want to use the European format. (when building a dashboard it may be confusing when using US notations in a company that is not used to do this) Is that possible?

---

<div class="post-metadata">

**Author:** ![dosant](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dosant/32/64489_2.png) [@dosant](https://discuss.elastic.co/u/dosant)\
**Post date:** [December 22, 2021, 1:12pm UTC](https://discuss.elastic.co/t/european-number-format-not-recognised/292606/4 "2021-12-22T13:12:32Z")

</div>

After you ingest your data as a `double` you can adjust the formatting in Kibana:

- Globally: Stack Management -\> Advanced settings -\> Number format
- Or per field: Stack Management -\> Index patterns -\> your index pattern -\> edit your field and change formatting

---

<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:** [January 19, 2022, 1:12pm UTC](https://discuss.elastic.co/t/european-number-format-not-recognised/292606/5 "2022-01-19T13:12:38Z")

</div>

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