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.
Sorry, I found the solution. For anyone else out there having the same issue in the future, I used REPLACE([String], Char(10), " ") to fix the issue. CHAR(10) = line break.