Correct way of Convert Enhanced Rich Text field to Plain Text (multiline) - Sharepoint 2013

Question

I changed a type of a Enhanced Rich Text column to Plain Text field.

I am seeing similar to the following content in the text field now.

<div class="ExternalClass3227FAEFAC38465BADF8165D56926D99"><p>This is used the text 16&#58;50&#160;​</p></div>

I wrote C# program (with CSOM) to iterate through each list item and strip the html tags and set just the text. I used regex, to strip html tags as mentioned in this post. It does remove the html tags, but it doesnt remove the html characters within the text. I tried, FieldValueAsText and didnt work for me.

I would like to know what the correct way is to achieve this.

Answer 1

You can create another Plain text type column, use the code snippet to get text value from Enhanced rich text column using CSOM then set the Plain Text column with the text value got:

        ClientContext oClientContext = new ClientContext("http://sp/sites/MyDev");


        List list = oClientContext.Web.Lists.GetByTitle("List5");
        ListItem item = list.GetItemById(1);

        oClientContext.Load(item,a=>a.FieldValuesAsText);
        oClientContext.ExecuteQuery();
        item["Test1"]=item.FieldValuesAsText["Test"];
        item.Update();
        oClientContext.ExecuteQuery();