External Table - data contains newline character
I create an external table. Where my data is pipe-delimited. For the most part my data is clean, but there are several rows that have new line characters (\n) in the middle of the text. My line ending is the new line character.
I am on a 10g instance (10.2.0.3). There is a small chance this will go to 11gR1 this year, but I have no control or insight to that decision.
Reading the documentation, I see that LRTRIM should remove the trailing line feed ("
Spaces include blanks and other nonprinting characters such as tabs, line feeds, and carriage returns.
", http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/et_params.htm#i1009527)
0