OraFAQ Forum: Server Utilities » Loading a CSV with records containing newline.

Home » RDBMS Server » Server Utilities » Loading a CSV with records containing newline.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Loading a CSV with records containing newline. [message #368162]

Mon, 18 September 2000 10:17

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 22:24:09 CST 2025