Convert fields of datatype text to int or float in Kibana

[ppisljar (Peter Pisljar)]

You can convert data real time using scripted fields but the performance implications are huge (it will be a lot slower than having those fields indexed as correct data type)

Using Painless in Kibana scripted fields

Painscript Script - cast String as Int?

We have a mapping issue that will be addressed soon for a field that should be an int but is presently a string. All values in the index should cast cleanly. Anyhow, in a pinch I wanted to aggregate some data on the field and thought creating a scripted field in K5 would be a temp solution. Can anyone point me in the right direction or provide a code example? I tried several things including (int)['doc.myfield'].value and also parseInt(string) as documented at https://docs.oracle.com/javase/…