# Regex and Scripted fields help

**URL:** <https://discuss.elastic.co/t/regex-and-scripted-fields-help/162007>\
**Category:** Kibana\
**Created:** [December 24, 2018, 2:34pm UTC](https://discuss.elastic.co/t/regex-and-scripted-fields-help/162007 "2018-12-24T14:34:47Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![camay123](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@camay123](https://discuss.elastic.co/u/camay123)\
**Post date:** [December 24, 2018, 2:34pm UTC](https://discuss.elastic.co/t/regex-and-scripted-fields-help/162007/1 "2018-12-24T14:34:47Z")

</div>

I am trying to extract bitcoin address from eml body that are indexed into elasticsearch.

I am trying to use a scripted field for it with the following script:

```
if (!doc["emlBody.keyword"].empty) { 
def m = /(: )([1,3]{1}[a-zA-Z0-9]{25,34})/.matcher(doc["emlBody.keyword"].value); 
if (m.matches()) { return m.group(2) } 
else { return "no match" } 
} 
else { return "NULL"}

```

However, after checking my data it seems that I rarely enter the first if section, and just get "NULL" results, when i should have at least a "no match" or the correct bitcoin address.

I am a bit lost, just not certain why this doesnt work.

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [December 24, 2018, 2:47pm UTC](https://discuss.elastic.co/t/regex-and-scripted-fields-help/162007/2 "2018-12-24T14:47:07Z")

</div>

you can try and switch to this check for empty email body: `if(doc["emlBody.keyword"].value !=null)` I've found it works best.

---

<div class="post-metadata">

**Author:** ![camay123](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@camay123](https://discuss.elastic.co/u/camay123)\
**Post date:** [December 24, 2018, 3:15pm UTC](https://discuss.elastic.co/t/regex-and-scripted-fields-help/162007/3 "2018-12-24T15:15:21Z")

</div>

Yes, I tried, but no luck.

---

<div class="post-metadata">

**Author:** ![camay123](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@camay123](https://discuss.elastic.co/u/camay123)\
**Post date:** [December 24, 2018, 3:37pm UTC](https://discuss.elastic.co/t/regex-and-scripted-fields-help/162007/4 "2018-12-24T15:37:27Z")

</div>

if i use the "emlBody" field after setting fielddata=true i get a more expected results, I get "no match" results instead of "NULL" so it does mean i am entering the if statement, but my regex doesnt seem to pickup.

---

<div class="post-metadata">

**Author:** ![sebastien](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sebastien/32/36119_2.png) [@sebastien](https://discuss.elastic.co/u/sebastien)\
**Post date:** [December 25, 2018, 12:22pm UTC](https://discuss.elastic.co/t/regex-and-scripted-fields-help/162007/5 "2018-12-25T12:22:00Z")

</div>

Hi camay123  
,  
Could you share the format of the `emlBody` field so we can check your regex expression?

Cheers

---

<div class="post-metadata">

**Author:** ![camay123](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@camay123](https://discuss.elastic.co/u/camay123)\
**Post date:** [December 25, 2018, 1:52pm UTC](https://discuss.elastic.co/t/regex-and-scripted-fields-help/162007/6 "2018-12-25T13:52:30Z")

</div>

The Field as a Type and Format of String.

I believe this regex would be more appropriate for bitcoin address:

```auto
(: )([13][a-km-zA-HJ-NP-Z1-9]{25,34})

```

However, both should work, but are not. Here is the part of a sample email:

```
Hello,
<br><br>
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent sit amet imperdiet elit. Donec sapien orci, rutrum id odio quis, dictum facilisis velit.
<br><br>
Aliquam auctor pulvinar sapien. Ut ut mi fermentum, tempor ex sed, ultricies tellus: 1K8TqsB2C1iY8qdGqhnHfgen3uE8GBU7c8 
<br><br>
Aliquam nunc purus, porta non rutrum id, luctus consequat tortor. Maecenas sollicitudin mi vel nisi ultricies, eget blandit mauris feugiat. Fusce et porttitor sem.

```

---

<div class="post-metadata">

**Author:** ![sebastien](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sebastien/32/36119_2.png) [@sebastien](https://discuss.elastic.co/u/sebastien)\
**Post date:** [December 25, 2018, 3:01pm UTC](https://discuss.elastic.co/t/regex-and-scripted-fields-help/162007/7 "2018-12-25T15:01:11Z")

</div>

I forgot to ask: did you activate regex in your `elasticsearch.yml` file?

```auto
script.painless.regex.enabled: true

```

---

<div class="post-metadata">

**Author:** ![camay123](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@camay123](https://discuss.elastic.co/u/camay123)\
**Post date:** [December 25, 2018, 7:19pm UTC](https://discuss.elastic.co/t/regex-and-scripted-fields-help/162007/8 "2018-12-25T19:19:31Z")

</div>

yes I Did add this line in my yml file and then restarted ES

is their a way to confirm this is active ?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 22, 2019, 7:19pm UTC](https://discuss.elastic.co/t/regex-and-scripted-fields-help/162007/9 "2019-01-22T19:19:32Z")

</div>

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