Xref: alice comp.databases.oracle.server:26529
Path: alice!news-feed.fnsi.net!news.idt.net!newshub.northeast.verio.net!cpk-news-hub1.bbnplanet.com!news.bbnplanet.com!newsfeed.internetmci.com!192.220.250.21!netnews1.nw.verio.net!netnews.nwnet.net!news-hub.interserv.net!news.sprynet.com!not-for-mail
From: Adrian Hands <AHands@sprynet.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Embedded CTRL-ENTER in Text File??
Date: Sat, 08 Aug 1998 16:24:49 -0400
Organization: Metro IS
Lines: 59
Message-ID: <35CCB411.9F0D4C4D@sprynet.com>
References: <01bdc2bc$142437c0$982aa1cd@winni.tiac.net>
Reply-To: AHands@unforgettable.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.03 [en] (X11; U; Linux 2.0.27 i586)
To: Hank Riehl <hankr@skillview.com>

This ain't what you wann hear but...The other answer you got is correct.

\0x0d\0x0a = chr(13)||chr(10) = carriage return + line-feed
(not control-enter)

what are you using to view your sybase output?
look closely,
ms-dos/win systems use 0d 0a as the end-of-record mark, so, if your
records contain 0d 0a, you're hosed because you can't tell an
end-of-record from an embedded crlf.

If you're using a unix system: unix uses 0a (without 0d) as an
end-of-record mark so you stand a better chance of making something
logical out of your sybase dump.

You'll probably need to setup a perl, vb, or... program to clean-up your
sybase data before loading it into oracle.

Sounds like your records lengths are variable...that's going to make it
tough.
Are you're fields comma-delimited ?  Are your alpha fields quoted ?  If
so, that'll make the job easier.

Can you alter your sybase dump routine to put some character at the
start of your record for you to use
as a marker in determining which crlfs are end-of-record and which are
embedded in your strings ?

Are these really huge files ?  If not, you might want to write some
PL/SQL on the oracle side to load the data using UTL_FILE and do your
conversions there.

Hank Riehl wrote:
> 
> We have several ASCII delimited files which are table-outputs from Sybase
> we want to bring into Oracle via SQL*Loader.
> 
> Some longer VARCHAR2 columns have data which contain embedded CTRL-ENTERs,
> for user-formatting within the column (bullet lists, etc.). Sybase's
> ASCII-file outputs the embedded CTRL-ENTER as "\x0d\x0a".
> 
> Does anyone know what character-combination I must replace this with (in
> Wordpad) so that Oracle will interpret the same meaning... and
> "embedded-ENTER"? An answer from another newsgroup indicated...
>    CHR(13)||CHR(10)
> but I'm afraid that Oracle will simply inpertret these as literal
> characters on the import rather than special-meaning control-characters.
> 
> Can anyone verify that this is correct, or if not, what it should be?
> 
> Thanks

-- 
Adrian Hands
Raleigh, NC

panic: attempt to recv circular datagram in round socket!
panic: stack pointer is read-only!
$