Home » RDBMS Server » Server Utilities » SQLLDR - Removing CR/LF in Text Fields
SQLLDR - Removing CR/LF in Text Fields [message #184989] Sat, 29 July 2006 11:07 Go to next message
dtipres
Messages: 1
Registered: July 2006
Junior Member
Does anyone know the easiest way to get rid of CR/LF characters in text fields, since SQLLDR thinks that's an end of record character?
Or, even better, to preserve those characters in that one column only.

Thanks for any help you can give.
Re: SQLLDR - Removing CR/LF in Text Fields [message #184993 is a reply to message #184989] Sat, 29 July 2006 11:18 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Does anyone know the easiest way to get rid of CR/LF characters in text fields,
I'd use the tr command
$ man tr
Previous Topic: SQL * Loader issue
Next Topic: wwsec_persons$ problem when restoring full dmp of 817 portal
Goto Forum:
  


Current Time: Thu Dec 08 02:12:21 CST 2016

Total time taken to generate the page: 0.08258 seconds