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

"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

Pick yet another character (how about a tilde? ~ ) and use that. Also maybe enclose your alpha columns in double quotes - that might help your destination program recognize the data, but that really depends on the destination program itself - check and see if enclosing in double quotes each alpha column might help you.

-Matt Received on Mon Jan 29 2001 - 02:34:24 CET