Extract text inside quotes

[ronaldbalza2023]

Hello everyone, I am trying to figure out how to extract the text that is enclosed within certain characters. Specifically, I would like to extract the name. Thank you for your help.

 

<span class="63f561bef77505002913b22d">John Doe</span>

[Ahmedx · Accepted solution]

see attached
https://dropmefiles.com/EEgeC

[vicky_]

In Power Query, you can go to Transform > Extract > Text Between Delimiters. 
If you need to do it in DAX, then try:

Text Between Quotes = 
var startIndex = SEARCH(">", [columnName]) // find the index of the first > character
var remainingText = LEFT([columnName], LEN([columnName]) - startIndex)
var endIndex = SEARCH("<", [columnName]) // find the index of the next quote character (starting from the startIndex)
return LEFT(remainingText, endIndex)

(I haven't tested the code, so you will need to do some tweaking. Hopefully you get the idea)