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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors