none
Exporting an Multi-line RTF column into a CSV file RRS feed

  • Question

  • Hello.   I am exporting a variety of fields to a CSV file with no issues, except for one.  The last line in this snippet (Body) is a multi-line RTF field, and is exporting all the HTML coding in the filed.  Is there a way to convert this to plain text in my CSV file?

    This is for Sharepoint Online.  To be clear, the program I have outputs all the fields with no issues, its just a formatting issue on this one field.

        $ExportItem = New-Object PSObject
        $ExportItem | Add-Member -MemberType NoteProperty -Name "Title"             -value $_["Title"]
        $ExportItem | Add-Member -MemberType NoteProperty -Name "Activity Type"     -value $_["ActivityType"]
        $ExportItem | Add-Member -MemberType NoteProperty -Name "Discussion Date"   -value $_["DiscussionDate"]
       $ExportItem | Add-Member -MemberType NoteProperty -Name "Body"              -value $_["Body"]

    Tuesday, August 20, 2019 12:54 PM