Hi All, Due to a mapping mistake I have a number field mapped as a string. I have updated my mapping already to integer so that is fixed. Due to the amount of indices and the amount of data is re-indexing not an option. To move forward I want to add an scripted field that converts the string to an …

I ended up with this. if (doc.containsKey('rcptto_count') ) { if (doc['rcptto_count.keyword'] != null) { return Integer.parseInt(doc['rcptto_count.keyword'].value) } } So, who knows it might help some one :slight_smile:

Painless string to int

Elastic Stack Elasticsearch

dadoonet (David Pilato) March 19, 2019, 2:05pm 2

I think this is not producing a boolean:

doc['rcptto_count.keyword']

So you should probably test with:

doc['rcptto_count.keyword'] != null

1 Like

Topic		Replies	Views
Convert string field in number using painless script in existing index kibana Kibana	2	12303	February 7, 2018
Convert String to Integer using Painless Kibana	4	25827	May 18, 2018
Converting a text field to integer via painless or expression- impossible? Kibana	2	5364	September 25, 2017
Kibana Scripted field : Not able to parse the String to Double/Int Elasticsearch painless	1	670	August 23, 2021
How to convert number to string using painless script and visualize it in kibana Kibana	4	3432	December 27, 2018

Painless string to int

Related topics