Database Utilities (MOSC)

MOSC Banner

External Table - data contains newline character

edited Mar 25, 2011 3:13AM in Database Utilities (MOSC) 1 commentAnswered
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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center