Home » RDBMS Server » Server Utilities » Loading a CSV with records containing newline.
Loading a CSV with records containing newline. [message #368162] Mon, 18 September 2000 10:17 Go to next message
Amrik Thethi
Messages: 1
Registered: September 2000
Junior Member
Can sql*loader load a CSV file in which some fields contain a newline? I've tried everything I know (which is not much). SQL*Loader thinks that the record ends on the newline even though the whole field is enclosed in quotes.

Report message to a moderator

Re: Loading a CSV with records containing newline. [message #368165 is a reply to message #368162] Tue, 19 September 2000 11:50 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,
NO sql loader will think its a new line.

You have to use utl file package.
Or use any scripting language like perl or shell
to remove the new line. And then use sql*loader.

Thanks
Bala

Report message to a moderator

Previous Topic: Re: RMAN and Omniback
Next Topic: How to Remove and Reinstall OEM 1.6?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 04:05:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.