4 Replies Latest reply on Jun 16, 2015 7:10 AM by SriniVEERAVALLI

    Remove carriage return for string column in OBIEE

    BIAP

      Hi,

       

      Our data looks like this in Presentation:

      Aaa

      aaa

      aaa

       

      The first aaa and the second aaa are different. The second aaa has carriage return at the end in the database, so it looks like:

      "aaa

      "

      Length(Aaa) = 3, length(aaa) = 3, length(aaa) = 4

       

      My requirement is to show distinct value for this column. I can simply do this on database level by issuing "select distinct replace(lower(column_nme), chr(13))  from table". I need to achieve this in OBIEE report side without touching RPD and database. Can anyone help.

       

      Thanks

      VZ