AnsweredAssumed Answered

Inserting new line characters into query results?

Question asked by StevenJames on Jul 12, 2011
Latest reply on Jul 19, 2011 by another_martink
Hello all,
This is my first post, so please be gentle...
Firstly, a big thank you to all the contributors to this message board. It has been a valuable resource to me over the last few weeks whilst I have been tackling my first Clarity development tasks.
Using some good examples from here, I have successfully merged multiple records into a single field to display on a grid portlet with NSQL using the SYS_CONNECT_BY_PATH function and delimited the records with, for example, a comma.
However, what I would like to achieve is each record to start on a new line within the field rather than being delimited by a character.
So what I have tried so far is the wrap the SYS_CONNECT_BY_PATH function with the REPLACE function to replace the delimiter with chr(13) and chr(10) e.g.
REPLACE(SUBSTR(SYS_CONNECT_BY_PATH(CODE, ', '), 2),',',chr(13)||chr(10))
This doesn't appear to work when the portlet displays the data, the records remain on the same line. Has anybody else had any success splitting data onto multiple lines?

Cheers
Steve

Outcomes