OBIEE Analysis , new line break in a column

Hesh

Hi,

OBIEE 11g..

I have a column where I have a varchar text is displayed in my OBIEE Analysis. I need to split the text in to new lines in this column whenever there is a 'pull stop' and need to display that in a new line.

Sample column value:

" 1. some text here and more 2. this should be in the new line 3. And this as well "

desired out put: In the same column I have to split the value whenever there is a pull stop

" 1. some text here and more

2. this should be in the new line

3. And this as well "

I have used Replace function but it is only replacing first occurrence of pull stop and rest of the pull stops are ignored.. Translate can be a valid function but I did not find this function available!

Replace("SA_SM"."MoreComments",'. ','<br>')

Appreciate your help!

Regards

Hesh

Robert Angel

You might want to look into evaluate, this allows you to use any functions in your underlying database.

Though per the manual replace should work for you; -

SELECT REPLACE('JACK and JUE','J','BL') "Changes"

  FROM DUAL;

Changes

--------------

BLACK and BLUE