cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
yuvarajg Member
Member

how to extract the specific characters from text

HI

 

I have been extracting the data from sharepoint office 365 to power bi, here am facing one issue while extracting data from text. Could you please help me, how to extract the highlighted data into one new column.

 

Kindly refer the below screenshot.

1.png

 

Regards,

Yuvaraj

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: how to extract the specific characters from text

HI @yuvarajg,

 

You can try to use following formula to extract specific characters from other column:

Comment = 
VAR _left =
    FIND ( "<p>", [Element], 1, -1 )
VAR result =
    MID ( [Element], _left + 3, LEN ( [Element] ) - _left )
RETURN
    LEFT ( result, FIND ( "<", result, 1, -1 ) - 1 )

2.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
3 REPLIES 3
Super User
Super User

Re: how to extract the specific characters from text

yuvarajg Member
Member

Re: how to extract the specific characters from text

Hi

 

Thanks for your reply its working fine but for few rows its not as expected due to that delimeter range has been different for every row. Could you please provide any possibile solution to acheive this.

 

Regards

Yuvaraj

Community Support Team
Community Support Team

Re: how to extract the specific characters from text

HI @yuvarajg,

 

You can try to use following formula to extract specific characters from other column:

Comment = 
VAR _left =
    FIND ( "<p>", [Element], 1, -1 )
VAR result =
    MID ( [Element], _left + 3, LEN ( [Element] ) - _left )
RETURN
    LEFT ( result, FIND ( "<", result, 1, -1 ) - 1 )

2.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |