Re: When spooling a table to a delimited text file, how do I strip the delimiting character from the data itself?

From: Eric Givler <egivler_at_flash.net>
Date: Wed, 31 Jan 2001 15:44:10 GMT
Message-ID: <epWd6.3963$Nq6.170150_at_news.flash.net>

export it fixed width.

"Jim Cheoros" <jim_at_dataconversion.co.uk> wrote in message news:3A739B40.25C01FF3_at_dataconversion.co.uk...
> 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
>
>
Received on Wed Jan 31 2001 - 16:44:10 CET

This message: [ Message body ]
Next message: dmalto_at_mail.ru: "Re: When spooling a table to a delimited text file, how do I strip the delimiting character from the data itself?"
Previous message: Howard J. Rogers: "Re: strang table locking"
In reply to: Jim Cheoros: "When spooling a table to a delimited text file, how do I strip the delimiting character from the data itself?"
In reply to Jim Cheoros: "When spooling a table to a delimited text file, how do I strip the delimiting character from the data itself?"
Next in thread: dmalto_at_mail.ru: "Re: When spooling a table to a delimited text file, how do I strip the delimiting character from the data itself?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message