# Evaluating Fields or Stripping Data Out
**URL:** https://discuss.elastic.co/t/evaluating-fields-or-stripping-data-out/121151
**Category:** Kibana
**Created:** [February 23, 2018, 2:25am UTC](https://discuss.elastic.co/t/evaluating-fields-or-stripping-data-out/121151 "2018-02-23T02:25:23Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@thelonestargeek](https://discuss.elastic.co/u/thelonestargeek)
#### Post date: [February 23, 2018, 2:25am UTC](https://discuss.elastic.co/t/evaluating-fields-or-stripping-data-out/121151/1 "2018-02-23T02:25:23Z")
I have a field called "event time stamp" that is basically epoch time with commas in between, for example: "1,515,920,398,808"
Is there a way to format this into a timestamp in a kibana query? Essentially stripping the commas and then running an eval against that number to convert epoch to date/ time?
---
### Author:  [@LeeDr](https://discuss.elastic.co/u/LeeDr)
#### Post date: [February 23, 2018, 3:38pm UTC](https://discuss.elastic.co/t/evaluating-fields-or-stripping-data-out/121151/2 "2018-02-23T15:38:31Z")
I think you would want to try creating a scripted field for that. If you google "Kibana painless scripting" or anything close to that you'll find some great resources. Here's a couple of them.
> **[Using Painless in Kibana scripted fields
| Elastic](https://www.elastic.co/blog/using-painless-kibana-scripted-fields)**
>
> Kibana provides powerful ways to search and visualize data stored in Elasticsearch. For the purpose of visualizations, Kibana looks for fields defined in Elasticsearch mappings and presents them as op...
> **[How to Script Painless-ly in Elasticsearch](https://www.compose.com/articles/how-to-script-painless-ly-in-elasticsearch/)**
>
> With the release of Elasticsearch 5.x came Painless, Elasticsearch's answer to safe, secure, and performant scripting. We'll introduce you to Painless and show you what it can do. With the introduction of Elasticsearch 5.x over a year ago, we got a...
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 23, 2018, 3:38pm UTC](https://discuss.elastic.co/t/evaluating-fields-or-stripping-data-out/121151/3 "2018-03-23T15:38:37Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.