Re: Data with carriage return and SQL loader

Hi Dimitri,

can you replace the newlines and recode them with update after loading?

oli

On Mit, 11 Okt 2000, Dmitriy M. Labutin wrote:
> Dear All
>
> Could you please help me with loading comma delimited file into Oracle
> database on Windows NT.
>
> The problem is some data fields contain carriage return pair, for example
>
> 1,'abc
> def'
> 2,'data with carriage
> return'
> 3,'Data w/o carriage return'
>
> I can replace this pair with perl script, but I need carriage return present
> in the table - no replacement.
>
> Cheers,
> Dimitri
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dmitriy M. Labutin
> INET: Dmitriy_Labutin_at_ep.minsk.by
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
---

Oliver Artelt, System- und Datenbankadministration
---------------------------------------------------------------
  cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
   email: oli@cubeoffice.de # web: http://www.cubeoffice.de
---------------------------------------------------------------