Re: When spooling a table to a delimited text file, how do I strip the delimiting character from the data itself?
Date: Wed, 31 Jan 2001 19:21:17 GMT
Message-ID: <959oj1$sc5$1_at_nnrp1.deja.com>
Hi,
Try a tool at www.ispirer.com/chyfo.html
It can correctly convert data to a text file (CSV, TAB, fixed formats).
It also create control file for SQL Loader and CREATE TABLE statement.
Best regards, Dmitry.
In article <3A739B40.25C01FF3_at_dataconversion.co.uk>,
Jim Cheoros <jim_at_dataconversion.co.uk> wrote:
> Using SQLPlus, I'm trying to export some tables into ASCII delimited
files from Oracle 8.0. I don't have any problems doing this, except the
data itself contains the character I'm using to delimit the columns
with - so some individual fields in the output file wind up appearing
as several.
>
> Does anybody have any ideas on how to get around this? Unfortunately,
the data contains tabs, pipes, double & single quotes, asterisks, #, $,
etc, so I can't just use those as delimiters ...
>
> Thanks!
>
> Jim Cheoros
> --
> Advanced Downloading Ltd
> Tel: +44 (0)20 8789 5000
> http://www.dataconversion.co.uk
>
>
Sent via Deja.com
http://www.deja.com/
Received on Wed Jan 31 2001 - 20:21:17 CET