Description field export without HTML tags

[Nathalie Kapuya]

Hi all

Does anyone have insight into why the Description field contains HTML tags when exported to Excel for example?
Any input on how cleanse this field once it is exported via csv?

Thanks

[Sagi Gabay]

Hi Nathalie,

The Description field includes these HTML tags because it's part of the HTML data that's later being displayed in Rally. So, for example if you have a bolded word then the field saves the format as well and it'll be: <b>bolded word</b> . 

Our Excel add-in does have an option to strip out these HTML tags to allow you to export only the text. There is a checkbox towards the bottom of the export page. I don't recall it's exact name, but it's something like: "Strip XML Tags" (or similar name). You can use that to take out these tags.

Please let us know if that helped.

Sagi

[Nathalie Kapuya]

Hi Sagi 

Thanks for the fast response. I am aware of this option via the Rally excel add-in, however the extract scenario I have is based on an extract exported from an internal custom dashboard. 
Would be ideal if the exported Description field presented without the HTML tags when extracted to Excel.

[Sagi Gabay]

Hi Nathalie,

The Description field holds the HTML tags as part of the actual value and uses them to display in Rally. So, for example if you have a bolded word , it is stored as <b>bolded word</b> in the Description field. It's part of the value.

The Excel add-in does have a check box that allows you to strip out XML tags during export. You shall see towards the bottom a checkbox named: "String XML tags", you can use it to get rid of the HTML tags and export only the text value of the Description field.

Please let us know if that helped.

Sagi

[Jarrod Reed]

Hi @Nathalie Kapuya,

If you are using Excel you could do this.

1. Open in Excel.
2. Navigate to the cell with the HTML tags you want to delete.
3. Press Ctrl + H .
4. Type the HTML tags in the cells that you want to delete in the "Find what" field.
5. Leave the "Replace with" field blank.
6. Click Replace All.

------------------------------
Jarrod Reed
Broadcom Solution Engineer | Domain Specialist ValueOps (Clarity & Rally)
------------------------------

[Nathalie Kapuya]

Thanks for the workaround suggestion Michael. Users would ideally prefer to not follow these steps :-) as the exported Description can contain multiple formats as per my example below. 

I will submit an idea via Rally. 

Example 

<p><strong><u>ladada</u></strong><u><strong>:</strong></u></p> <p>Description: ladada&nbsp;ladada&nbsp;ladada.</p> <p>&nbsp;</p> <p>ladada:</p> <ul>  <li>ladada&nbsp;ladada&nbsp;</li> </ul> <p>&nbsp;</p> <p><u><strong>ladada:</strong></u></p> <ul>  <li>ladada(tadada) ladada.</li> </ul>