Re: HELP ASP (ORACLE V7 + EXCEL)

From: Mark Gumbs <mgumbs_at_hotmail.com>
Date: Thu, 11 Mar 1999 09:47:33 -0000
Message-ID: <36e78fe2.0@145.227.194.253>

The good news is that i have done this before. The bad news is that i haven't got the exact code to hand!

Anyway, find the ascii value of a carriage return (it may be 12 or 10 but check anyway).
In your statement that output the fields, enclose it in a replace statement. e.g Assuming that the ascii for a carriage return is 12

replace(<string>, chr(12), '')

This will replace a carriage return with a null. I remember in the past that the faulty line in excel could either be a carriage return OR a line feed so if you do not have success eliminating the carriage return, find the ascii value for a line feed and repeat.

Enjoy.

Mark

Francoise Bouffard wrote in message <36E6A623.D4991870_at_micst.gouv.qc.ca>...
>Dear friends,
>
>I must create a file for EXCEL with data coming from Oracle V7. In
>fields varchar2 from one of my table in Oracle I find a
>carriage-return. How can I remove this carriage-return (which causes a
>problem when I recover my file in Excel) of my fields varchar2. With
>PL/SQL or SQL??? how??
>
>Thanks in advance.
>
>Françoise.
>
Received on Thu Mar 11 1999 - 03:47:33 CST