Regex on filtered data on Kibana

Elastic Stack Kibana
1

Hi, is there any feature that can add regex and show the data on visualization?
Like Name is 123@bc.com. it should show only 123

2

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.

Screenshot 2022-12-05 at 12.46.49
Screenshot 2022-12-05 at 12.46.491186×998 132 KB

Screenshot 2022-12-05 at 12.47.07
Screenshot 2022-12-05 at 12.47.071920×1680 117 KB

3

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
Output is 1234567...

4

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.

5

Sure. Do you have any sample of custom script?

6

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):

def email = doc["email"].value;
if (email != null) {
    int index = email.indexOf('@');
    if (index > 0) {
        emit(email.substring(0, index));
        return;
    }
}
emit("");
7

hi,

can i map the newly created filed to the old field available in the Elasticsearch?

9

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