# Extrair Número de String

**URL:** <https://community.eazybi.com/t/extrair-numero-de-string/12376>\
**Category:** Questions & Answers\
**Created:** [April 14, 2023, 2:39pm UTC](https://community.eazybi.com/t/extrair-numero-de-string/12376 "2023-04-14T14:39:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gustavo\_Mariano](https://community.eazybi.com/user_avatar/community.eazybi.com/gustavo_mariano/32/9254_2.png) [@Gustavo\_Mariano](https://community.eazybi.com/u/Gustavo_Mariano)\
**Post date:** [April 14, 2023, 2:39pm UTC](https://community.eazybi.com/t/extrair-numero-de-string/12376/1 "2023-04-14T14:39:06Z")

</div>

Olá, sou novo no EazyBi, gostaria de extrair um número específico dos nomes das Issues mas não está funcionando.

> **[Screenshot-2 hosted at ImgBB](https://ibb.co/XsnNwbH)**
>
> Image Screenshot-2 hosted in ImgBB

Este código: “/\d{11}/gm” funciona em regex, mas não consigo adaptar para o EazyBI.

Preciso de um campo que exiba apenas o que está selecionado em vermelho.

Podem me ajudar?

---

<div class="post-metadata">

**Author:** ![nauris.malitis](https://community.eazybi.com/user_avatar/community.eazybi.com/nauris.malitis/32/6355_2.png) [@nauris.malitis](https://community.eazybi.com/u/nauris.malitis)\
**Post date:** [April 26, 2023, 5:02pm UTC](https://community.eazybi.com/t/extrair-numero-de-string/12376/2 "2023-04-26T17:02:48Z")

</div>

Hi @Gustavo_Mariano

When using the **Issue** dimension in Rows, you can define a new calculated measure in the **Measures** dimension in Columns with the following formula that uses the [ExtractString](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/extractstring) function:

```auto
ExtractString([Issue].CurrentHierarchyMember.GetCaption,"\d{11}")

```

This should return eleven sequential numbers from the name of the Issue.

​​Let me know if this works as expected!  
​Best regards,  
​Nauris / eazyBI support