How to extract a string by follow a value (substring)

[Lucas_Silva_Dantas_A]

Hello good morning i would like to know a way to take all string content after a word in my case the word that i would like to take all content after is the word "Executor: " only showing the name after this and remove the word executor, showing only the word after the "Executor: "

Executor: (Executor = responsible by task)

for exemplo in this issue

Analisar o desenho da solução ------- Executor: Flávio

i would like to show only the word after the executor in this casee

Flávio

I already tried this measure but show some letters of the word executor:

right([Concept].CurrentMember.Name,10)

i too already tried

Val(ExtractString([Issue].CurrentHierarchyMember.get('Executor:'),' ',1))

but donsen`t show anyting

[janis.plume]

Hi,

The ExtractString function is the right way to go in this case. The second parameter in this function is a regex for extracting string.

The following regex should do that in your case:

'.*Executor:(.*)'

If you extract the Executor from the issue summary, the formula is the following

ExtractString([Issue].CurrentHierarchyMember.GetCaption,'.*Executor:(.*)',1)

Kindly,
Janis, eazyBI support