Prev: Dynamic Cursor
Next: Professional C++
From: dn.perl on 18 Jun 2010 01:49
I use Oracle SQL Developer, ver 2.1, to access an Oracle 10g server. I
would like to export a LONG field into an excel sheet. Sometimes it
works, sometimes not, and I have not been able to find out the
boundary beyond which it fails. I can export it into a csv file and
then open it an an excel file, but the LONG field contains several
tabs and several commas within it. And formatting that data correctly
so that excel organizes it the way I want (correct field in correct
column) is proving a bit tiresome.

Can Oracle SQL Developer or TOAD be configured to read (say) 2,000
characters of a LONG field, truncate the rest, and reliably export
this data (with a limit of characters in a LONG field) into an Excel
sheet?

Please advise; thanks in advance.

From: joel garry on 21 Jun 2010 19:45
On Jun 17, 10:49 pm, "dn.p...(a)gmail.com" <dn.p...(a)gmail.com> wrote:
> I use Oracle SQL Developer, ver 2.1, to access an Oracle 10g server. I
> would like to export a LONG field into an excel sheet. Sometimes it
> works, sometimes not, and I have not been able to find out the
> boundary beyond which it fails. I can export it into a csv file and
> then open it an an excel file, but the LONG field contains several
> tabs and several commas within it. And formatting that data correctly
> so that excel organizes it the way I want (correct field in correct
> column) is proving a bit tiresome.
>
> Can Oracle SQL Developer or TOAD be configured to read (say) 2,000
> characters of a LONG field, truncate the rest, and reliably export
> this data (with a limit of characters in a LONG field) into an Excel
> sheet?
>
> Please advise; thanks in advance.

Also note you can protect commas and tabs with double quotes, as you
could see by saving excel files as csv's.

jg
--
@home.com is bogus.
http://www.boston.com/bostonglobe/ideas/articles/2010/06/13/the_bright_side_of_wrong/
From: Shakespeare on 22 Jun 2010 03:08
Op 22-6-2010 1:45, joel garry schreef:
> On Jun 17, 10:49 pm, "dn.p...(a)gmail.com"<dn.p...(a)gmail.com> wrote:
>> I use Oracle SQL Developer, ver 2.1, to access an Oracle 10g server. I
>> would like to export a LONG field into an excel sheet. Sometimes it
>> works, sometimes not, and I have not been able to find out the
>> boundary beyond which it fails. I can export it into a csv file and
>> then open it an an excel file, but the LONG field contains several
>> tabs and several commas within it. And formatting that data correctly
>> so that excel organizes it the way I want (correct field in correct
>> column) is proving a bit tiresome.
>>
>> Can Oracle SQL Developer or TOAD be configured to read (say) 2,000
>> characters of a LONG field, truncate the rest, and reliably export
>> this data (with a limit of characters in a LONG field) into an Excel
>> sheet?
>>
>> Please advise; thanks in advance.
>
> Also note you can protect commas and tabs with double quotes, as you
> could see by saving excel files as csv's.
>
> jg
> --
> @home.com is bogus.
> http://www.boston.com/bostonglobe/ideas/articles/2010/06/13/the_bright_side_of_wrong/

Or just use different field seperators.

Shakespeare
From: joel garry on 22 Jun 2010 16:23
On Jun 22, 12:08 am, Shakespeare <what...(a)xs4all.nl> wrote:
> Op 22-6-2010 1:45, joel garry schreef:
>
>
>
> > On Jun 17, 10:49 pm, "dn.p...(a)gmail.com"<dn.p...(a)gmail.com>  wrote:
> >> I use Oracle SQL Developer, ver 2.1, to access an Oracle 10g server. I
> >> would like to export a LONG field into an excel sheet. Sometimes it
> >> works, sometimes not, and I have not been able to find out the
> >> boundary beyond which it fails. I can export it into a csv file and
> >> then open it an an excel file, but the LONG field contains several
> >> tabs and several commas within it. And formatting that data correctly
> >> so that excel organizes it the way I want (correct field in correct
> >> column) is proving a bit tiresome.
>
> >> Can Oracle SQL Developer or TOAD be configured to read (say) 2,000
> >> characters of a LONG field, truncate the rest, and reliably export
> >> this data (with a limit of characters in a LONG field) into an Excel
> >> sheet?
>
> >> Please advise; thanks in advance.
>
> > Also note you can protect commas and tabs with double quotes, as you
> > could see by saving excel files as csv's.
>
> > jg
> > --
> > @home.com is bogus.
> >http://www.boston.com/bostonglobe/ideas/articles/2010/06/13/the_brigh...
>
> Or just use different field seperators.
>
> Shakespeare

How many ways does Excel blow? Don't get me started...

jg
--
@home.com is bogus.
http://thedailywtf.com/Articles/A-Gracious-Grace-Period.aspx
From: galen_boyer on 22 Jun 2010 20:25
"dn.perl(a)gmail.com" <dn.perl(a)gmail.com> writes:

> I use Oracle SQL Developer, ver 2.1, to access an Oracle 10g server. I
> would like to export a LONG field into an excel sheet. Sometimes it
> works, sometimes not, and I have not been able to find out the
> boundary beyond which it fails. I can export it into a csv file and
> then open it an an excel file, but the LONG field contains several
> tabs and several commas within it. And formatting that data correctly
> so that excel organizes it the way I want (correct field in correct
> column) is proving a bit tiresome.
>
> Can Oracle SQL Developer or TOAD be configured to read (say) 2,000
> characters of a LONG field, truncate the rest, and reliably export
> this data (with a limit of characters in a LONG field) into an Excel
> sheet?

You know, this post really urks me. Its as though its the database's
job to somehow make sure excel can handle something.

--
Galen Boyer

--- news://freenews.netfront.net/ - complaints: news(a)netfront.net ---
 | 
Pages: 1
Prev: Dynamic Cursor
Next: Professional C++