CHR(10) function doesn't work in OBIEE
711658Jul 16 2009 — edited Jul 16 2009Hi
I wanted to display multiple column values in the same cell in OBIEE.
In order to achieve this, I concatenated all the columns into a single column separated by CHR(10).
This works fine in SQL, but doesn't work in OBIEE.
Columns in the table
Address1 City State Country Zip Code.
12345, Main Street Fullerton California USA 92835
The Result needed
12345, Main Street
Fullerton
California
USA 92835
This is a specific requirement.
Essentially, I need to know how can we have new line/carriage return/next line on OBIEE?
Your earliest help would be highly appreciated
Thanks
~Vijay