Re: Convert Oracle data to EXCEL

From: <dmalto_at_my-deja.com>
Date: Thu, 14 Dec 2000 15:16:50 GMT
Message-ID: <91ao8q$rhq$1@nnrp1.deja.com>

  When Excel saves data it doesn't enclose data by " if there are not , or "
  But IBM DB2 (export command) encloses every char column by ". But it isn't necessary and takes more space.
  Every " (double quote) is duplicated in CSV file

For example:

  abc,d - "abc,d"
  abcd,"d - "abc,""d"
  abcd,""d - "abc,""""d"
  a" - "a"""

Best regards, Dmitry

In article <91aj7i$mto$1_at_nnrp1.deja.com>, Luggy <dgh_consulting_at_my-deja.com> wrote:
> Dmitry,
>
> Fair point about data containing commas, but the output from the
script
> below IS strictly CSV format. What happens when you've got double-
> quotes in your data? This would screw up your solution.
>
> My PL/SQL script (the one I referred to) wraps each column with the
> encapsulator of your choice (double-quotes, or whatever else you may
> prefer). Note that the only encapsulator Excel seems to like is the
> double-quote (as Dmitry correctly specified), when opening a file as a
> CSV.
>
> Dave.
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 14 2000 - 09:16:50 CST