1 Reply Latest reply on May 15, 2013 12:46 PM by Alan Kwan

    String trimming in different lines

    Alan Kwan

      Hi all,


      I retrieve a clob field from oracle, and unfortunately originally source was in a messed up format that I don't want.


      This field is a comment field, an example of messed up value is:


      "The agent was

      very good in

      service, and that she was quick and responsive

      with her service."


      The comment gets broken up into different lines, and I am wondering if any of you have a solution for this.