how to extract the specific characters from text

[Anonymous]

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.

Regards,

Yuvaraj

[v-shex-msft · Accepted solution]

HI @Anonymous,

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 )

Regards,

Xiaoxin Sheng

[Zubair_Muhammad]

Hi

Try with this function

https://docs.microsoft.com/en-us/powerquery-m/text-betweendelimiters

[Anonymous]

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