How to preserve whitespace and newlines from CLOB using OEM Information Publisher

I am using OEM 13c and have created a simple Information Publisher report to query the job activity details and output the results for a specific job.

The select statement only has one column that happens to be a CLOB.

This is all working fine and the report shows the single row/column that I expected.

However the output has lost all the whitespace and end-of-line formatting and therefore appears as one long string.

Other posts on this forum have mentioned using <xsd:whiteSpace value="preserve"/> but do not give details on how to do so.

The article https://docs.oracle.com/cd/E24628_01/doc.121/e25161/info_pub.htm#EMPRF11310