New row when detects a character

[administracion_2]

Hi everyone;

 

I got a question/problem that i dont know how to resolve.

 

One field of my report, for example "Date" is taken from the result of:

 

array_to_string(array(    SELECT Date    FROM "X" x1    WHERE .......), ' || ') AS "Date",[/code]

 

 

With this, i want to take this result like, each date is a new row. Each group of character " || " makes of delimiter of a new row.

 

how can i do it?

 

Thanks to all;

 

Greeting.