# Regex on filtered data on Kibana
**URL:** https://discuss.elastic.co/t/regex-on-filtered-data-on-kibana/318916
**Category:** Kibana
**Created:** [November 15, 2022, 3:25am UTC](https://discuss.elastic.co/t/regex-on-filtered-data-on-kibana/318916 "2022-11-15T03:25:34Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Anil\_Alapati](https://discuss.elastic.co/u/Anil_Alapati)
#### Post date: [November 15, 2022, 3:25am UTC](https://discuss.elastic.co/t/regex-on-filtered-data-on-kibana/318916/1 "2022-11-15T03:25:34Z")
Hi, is there any feature that can add regex and show the data on visualization?
Like Name is [123@bc.com](mailto:123@bc.com). it should show only 123
---
### Author:  [@jughosta](https://discuss.elastic.co/u/jughosta)
#### Post date: [December 5, 2022, 11:48am UTC](https://discuss.elastic.co/t/regex-on-filtered-data-on-kibana/318916/2 "2022-12-05T11:48:47Z")
Hi @Anil_Alapati!
There is an option to create a new data view field, define a custom script for it, set a formatter if necessary and use the field later in visualizations.
---
### Author:  [@Anil\_Alapati](https://discuss.elastic.co/u/Anil_Alapati)
#### Post date: [December 5, 2022, 12:16pm UTC](https://discuss.elastic.co/t/regex-on-filtered-data-on-kibana/318916/3 "2022-12-05T12:16:39Z")
Hi,
Thank you. I did that. I can see the truncated string option.
Only problem is I am getting 3 dots extra. Any idea?
Input is [1234567@abcde.com](mailto:1234567@abcde.com)
Output is 1234567...
---
### Author:  [@jughosta](https://discuss.elastic.co/u/jughosta)
#### Post date: [December 5, 2022, 2:29pm UTC](https://discuss.elastic.co/t/regex-on-filtered-data-on-kibana/318916/4 "2022-12-05T14:29:48Z")
I would not recommend using "Truncated string" formatter here as it won't work for other values. Defining a custom script to parse and build a displayed value would be more flexible.
---
### Author:  [@Anil\_Alapati](https://discuss.elastic.co/u/Anil_Alapati)
#### Post date: [December 5, 2022, 2:42pm UTC](https://discuss.elastic.co/t/regex-on-filtered-data-on-kibana/318916/5 "2022-12-05T14:42:08Z")
Sure. Do you have any sample of custom script?
---
### Author:  [@jughosta](https://discuss.elastic.co/u/jughosta)
#### Post date: [December 6, 2022, 2:21pm UTC](https://discuss.elastic.co/t/regex-on-filtered-data-on-kibana/318916/6 "2022-12-06T14:21:07Z")
Hi @Anil_Alapati,
Here is an example how to get only the first part an email (if email field is named as "email", otherwise please adjust):
```auto
def email = doc["email"].value;
if (email != null) {
int index = email.indexOf('@');
if (index > 0) {
emit(email.substring(0, index));
return;
}
}
emit("");
```
---
### Author:  [@Anil\_Alapati](https://discuss.elastic.co/u/Anil_Alapati)
#### Post date: [December 14, 2022, 6:13am UTC](https://discuss.elastic.co/t/regex-on-filtered-data-on-kibana/318916/7 "2022-12-14T06:13:44Z")
hi,
can i map the newly created filed to the old field available in the Elasticsearch?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 11, 2023, 12:27am UTC](https://discuss.elastic.co/t/regex-on-filtered-data-on-kibana/318916/8 "2023-01-11T00:27:14Z")
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 8, 2023, 12:27am UTC](https://discuss.elastic.co/t/regex-on-filtered-data-on-kibana/318916/9 "2023-02-08T00:27:32Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.