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.

       

      Thanks,

      Alan