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: 25571
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: export tables in text files
Next Topic: problem with sql loader
Goto Forum:
  


Current Time: Sat Aug 19 10:11:37 CDT 2017

Total time taken to generate the page: 0.06724 seconds