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.

Report message to a moderator

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: 26766
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

Report message to a moderator

Previous Topic: SQL * Loader issue
Next Topic: wwsec_persons$ problem when restoring full dmp of 817 portal
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 08:01:20 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.