We have a database varchar2 field that can contain multiple strings delimited by the pipe character (e.g. 'abc|efg|hij'). I would like to display this field in an APEX interactive report with each string on a separate line:
abc
efg
hij
I can accomplish this in SQL with translate (e.g. translate(field), '|', chr(10)||chr(13) ). This does not work in the APEX interactive report-- even if I add "<span style="line-height:200%">#SUCCESS_BEFORE#</span>" to the Column Formatting HTML Express property.
Is there a way to accomplish this?
Thank you.