READ a LABEL BETWEEN TWO MARKED IN A TAG

[flavio65]

Hi 

I am a little in a crisis about how to deploy or found a good command for reading a label between two marked characters of a tag 

I have a text field, where generally is present somewhere the tag RCA_EN:<generic text># in this format

At this time I have deployed a formula able to find the tag "RCA_EN" in the cell but I am not able to find a way to read/print  the value between the two delimiters

In attach and power bi file used for this example that respect the original 

https://drive.google.com/file/d/1LHoTb5EaJ0fWTzZmWkwSlwCF6zYvuZGN/view?usp=share_link

thank you in advance for your help and suggestion 

[flavio65]

Hi tamerj1

Are you able to download the .pibx posted ??

In the while the raw data here 

https://docs.google.com/spreadsheets/d/1il_UP9gJqNNRdyRYNpezTOzOFLEeqpRv/edit?usp=sharing&ouid=10981...

[tamerj1 · Accepted solution]

@flavio65 
Apologies, I did not notice the link.

Please refer to attacjhed sample file with the proposed solution

Category = 
PATHITEM (
    SUBSTITUTE ( 
        SUBSTITUTE ( 'Table'[Comment], "RCA_EN:", "|" ),
        "#", 
        "|"
    ),
    2
)

[flavio65]

GREAT JOB

Not familiar with your suggestion   Thank you !

[tamerj1]

Hi @flavio65 

would you please provide a couple of examples (input - output)