how to remove html tags from string while generating report definition

[system]

hi,

We are using rich text editor to capture data on UI. so it is storing values with HTML tags in DB and Clipbaord.

So when we generating report definition it displaying values with html tags.

is there any possibilities to display data without html tags.

Please share the details and steps.

any help here is appreciated.

Thanks in advance

[KOMARINA (Srinivas Bharat Komarina)]

@BhargaviB3067 Hi, Greetings. Did you try this RUF pzUnescapeHTMLSpecialChars?

There are also other workarounds suggested in this post How to remove HTML tags from string, while displaying in RD | Support Center

Regards,

Bharat

[system]

@KOMARINA Thanks for response.

Can you please explain how to use ‘pzUnescapeHTMLSpecialChars’ in Report Definition?

[KOMARINA (Srinivas Bharat Komarina)]

@BhargaviB3067 You cannot directly in a RD but you can filter the data in the clipboard and store it without the HTML tags using the function, so by the time you run the report, there will be no tags in the data.

If you need a function to use directly in RD, please use pxReplace and replace <(.|\n)*?> with " ", again this is a workaround suggested in above post with a screen shot for reference if you need.

Regards,

Bharat

[system]

@KOMARINA I have tried pxReplace and replace <(.|\n)*?> with " " in Report definition, but didnt work. Report fetching data with Html tags. Attached sceenshots with my results

And I cannot use pzUnescapeHTMLSpecialChars since I fetching report for existing cases.

Currently We are using pega 7.4

Please suggest other scenarios.

Regards,

Bhargavi

[SaurabhG7134 (Saurabh Gupta)]

Hello @BhargaviB3067, can you try adding “RichTextDisplay” in the column format of your report and see if it meets your expectations.

Screenshot attached for the same. Hope this helps!!

Thanks,

Saurabh.