Description field type from HTML to String

[Deepa Karthiga]

Hi,

For a requirement, we changed the field type of Description from String to html and used for few days. But now we decided to change it back to String type.

The problem here is when we changed back to String, we see some tags in the existing record of incident, change, ritm and other task tables description(populated when the field type was html) field. Please help to resolve this.

Thanks in advance.

-Deepa

[Gurpreet07 · Accepted solution]

Below code converts HTML string to a text string. You need to run this code for subset of records and update the text string into that field

var gr = new GlideRecord('task');
gr.get('sys_id');
var htmlDesc = gr.description.getDisplayValue();

var txtDesc = htmlDesc.replace(/<(?:.|\n)*?>/gm, '');

gs.print(txtDesc);

[Deepa Karthiga]

Hi Gurpreet,

It worked, thank you :-).

Is there a way to convert plain text to html?

- Deepa

[Gurpreet07]

There's no such thing as there could be many possibilities of applying HTML to a plain text field...

[Deepa Karthiga]

Thank you.