I'm running Office 365 using PowerView, MS Project Professional and MS Project Server for a report application. However, when I bring in free text fields created in MS Project Server into my PowerView and Excel tables, it brings along the HTML tags with it. Does anyone know of a simple out of the box method to remove the tags?
<p>Here is where the project is:</p><p>-Comment 1</p><p>-Comment 2</p><p>-Comment 3</p>
Not sure is there is an out-of-box support for this. But I assume that you would first paste the fields inside Excel before using Power View. In that case, Excel's find and replace tool should do the trick right? Does this work for your case?
No resolution yet. As I'm pulling the field directly into PowerView, I don't have the luxury of very many Excel built in features as it pulls the data into PowerPivot tables. Though I'm sure this is not the correct terminology, remember, Project Manager - Not Programmer, it just seems to use Excel as the platform to bring it into to display it, not necessarily allowing you to use many of the built in excel features. I assume that is the trade-off for the power of the analytics of PowerPivot.
Good feature request for PV to process HTML tags. I will add it to the long backlog.
As a work around, it could be ugly, is to use Power Pivot Text functions like Replace or Substitute to remove the tags on those fields.
Brad Syputa, Microsoft Reporting Services This posting is provided "AS IS" with no warranties.
I would also recommend that you ensure your column settings are set to "Plain Text". It does take some of the fun out of what you see on the web. However, it makes for much cleaner Excel reports.
- Proposed as answer by fitcja Saturday, December 14, 2013 6:17 PM