Forum Discussion
Solved
How to remove html tags from some rows.
Hello I have a report that has web addresses in it. The addresses that go to a SharePoint site are fine, but the ones that point to a document have <Div class="external....... stuff before and after...
I was able to make a work around my changing my colomn type in the SharePoint list itself.
Can you share your data ? an example of the rows containing html tags?
I've had to change it a bit so I can share it, but its basically this.
| Data Sources |
| https://collaboration.ca/sites//SitePages/Home.aspx?web=1 |
| https://collaboration.ca/sites//SitePages/Home.aspx?web=1 |
| https://collaboration.ca/sites//SitePages/Home.aspx?web=1 |
| https://app.powerbi.com/groups/me/apps/cf8d9210-8aaa-4e69-a991-a5073bcf2509/reports/b95a573b-fcc0-438f-b922-8217e0c68a2c/ReportSection?experience=power-bi |
| https://collaboration.ca/sites//SitePages/Home.aspx?web=1 |
| null |
| https://app.powerbi.com/groups/me/apps/cf8d9210-8aaa-4e69-a5073bcf2509/dashboards/ec65c01e-89a6-4d5b-aa54-2838cd725823?experience=power-bi |
| https://collaboration.ca/sites/PI%20Dashboards%20%20Reports/Program%20Inventory%20Summary%20Dashboard%20FY%202022-23.pdf |
| https://collaboration.ca/sites/PI%20Dashboards%20%20Reports/Program%20Inventory%20Detailed%20Report%20FY%202022-23.pdf |
| https://collaboration.ca/sites/DRPRM-DPRGR/Lists/L1%20Contact%20List/AllItems.aspx?viewid=16da80ca-3cd8-4ee9-a57d-5ba6d8104e19&useFiltersInViewXml=1&web=1 |
| <div class="ExternalClass48A2FB7E4CCF4A14BD26D4E5E63F255E"><div style="font-family:Calibri, Arial, Helvetica, sans-serif;font-size:11pt;color:rgb(0, 0, 0);"><a href="https://collaboration.ca/sites/Public%20Documents/Forms/AllItems.aspx?csf=1&e=jvpUGa&web=1&RootFolder=/sitesR/Public%20Documents/Business%20Planning/BP%20Cycle%20Docs/BP%202024-25/L1%20Subs&FolderCTID=0x012000DA5BB5821A5BB54BA8E22E8C99761EC8">Directorate Resource Planning & Risk Management - DRPRM - L1 Subs - All Documents ()</a><br></div></div> |
| <div class="ExternalClassEB63DF80908F47A8B9317FF87A2D1554"><div style="font-family:Calibri, Arial, Helvetica, sans-serif;font-size:11pt;color:rgb(0, 0, 0);"><a href="https://collaboration.ca/sites/Public%20Documents/Forms/OE%20Dir.aspx?csf=1&e=OcVPoh&RootFolder=/sitesPublic%20Documents/Organization%20and%20Establishment%20Directive%20-%20Directive%20sur%20L%e2%80%99organisation%20et%20les%20Effectifs&FolderCTID=0x01200054A6647BE5A4FE46B4C01EFC6010CC02">Director Defence Force Planning (DDFP) - Organization and Establishment Directive - Directive sur L’organisation et les Effectifs - O&E Dir ()</a><br></div></div> |
| <div class="ExternalClass8DD2F5CACECA410B8697A81B3D4E5513"><div style="font-family:Calibri, Arial, Helvetica, sans-serif;font-size:11pt;color:rgb(0, 0, 0);"><a href="https://collaboration.ca/sites/DGDFP/DDFP/MOO/Forms/Default.aspx">MOO - Default ()</a><br></div></div> |
| <div class="ExternalClass1C1786A275B341298D0081D2D0CC3550"><div style="font-family:Calibri, Arial, Helvetica, sans-serif;font-size:11pt;color:rgb(0, 0, 0);"><a href="https://collaboration.ca/sites/Public%20Documents/Forms/AllItems.aspx"> - Public Documents - All Documents ()</a><br></div></div> |