Forum Discussion

ianbruckner's avatar
ianbruckner
Frequent Visitor
7 years ago
Solved

Remove text between html tags

I'm looking for help to remove html tags from a string.   Example input: <div class="ExternalClass742C332E0D0340C598BC9A78413A04DE">Staff going to storage training</div> Desired output: Staff goin...
Need Help
  • jsh121988's avatar
    jsh121988
    7 years ago

    You could try using PowerQuery Text Between function and use '>' and '</' as the delimiters.

     

    You can also do this in DAX using PATHITEM and SUBSTITUTE.

    InnerHTML = 
    PATHITEM( // Splits the string using delimiter "|", and takes the 2nd item that is a type of Text
        SUBSTITUTE( // Output <div class="Whatever"|Staff going to storage training|div>
            SUBSTITUTE([Html], ">", "|"), // Output <div class="Whatever"|Staff going to storage training</div>
            "</","|"
        ),
        2,
        TEXT
    )
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi ianbruckner ,

 

We can create a calculated column using DAX as well.

Column = 
VAR len =
    SEARCH ( ">", Table1[Column1],, BLANK () )
VAR len2 =
    SEARCH ( "</div>", Table1[Column1],, BLANK () )
RETURN
    MID ( Table1[Column1], len + 1, len2 - len - 1 )

 

Regards,

Frank

 

sizi's avatar
sizi
Helper II
2 years ago

Hello. I tried your query it worked partially and i still have below html tags in the content which needs to be removed. 

 

<div style="font-family&#58;Calibri, Arial, Helvetica, sans-serif;font-size&#58;11pt;color&#58;rgb(0, 0, 0);">communication started with recruitment team section head in order to assign contact person,<br>i asked the BRM to follow up on that as&#160;<span style="font-family&#58;Calibri, Arial, Helvetica, sans-serif;background-color&#58;rgb(255, 255, 255);display&#58;inline !important;">recruitment team section head didn't reply to the email yet</span>

 

The highlighted in green should be the outcome. Kindly help,