Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
flavio65
New Member

READ a LABEL BETWEEN TWO MARKED IN A TAG

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

 

manual.JPG

 

problem.JPG

 

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 

1 ACCEPTED SOLUTION

@flavio65 
Apologies, I did not notice the link.

Please refer to attacjhed sample file with the proposed solution

3.png

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

View solution in original post

4 REPLIES 4
flavio65
New Member

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...

 

@flavio65 
Apologies, I did not notice the link.

Please refer to attacjhed sample file with the proposed solution

3.png

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

GREAT JOB

 

Not familiar with your suggestion   Thank you !

tamerj1
Super User
Super User

Hi @flavio65 

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.