Toad World® Forums

RE: Export grid to csv problem (bug!?)

With “Include delimiter after last column” unchecked -

The delimiter is only intended to be shown between columns. Since you have only one column, there is no delimiter.

With “Include delimiter after last column” checked -

The delimiter is intended to be shown between columns, and at the end of the row. Since you have only one column, the only delimiter will appear at the end
of each row.

Seems like it is working normally to me.

From: damir.vadas_531 [mailto:bounce-damirvadas_531@toadworld.com]

Sent: Monday, October 14, 2013 4:11 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Export grid to csv problem (bug!?)

Export grid to csv problem (bug!?)

Thread created by damir.vadas_531

Toad 12.1

Oracle client 11.2.0.3.0/Db 11.2.0.3.0 x64 (all)

When exporting small grid to delimited text (comma based INTEGER based field) with option like on picture. I get result like in red rounded corner (no comma as separator!):

when I assign export settings to activate (Include delimiter after last column), comma is shown (as expected):

Do not know if NLS is important to reproduce this case but think it is not.

Brg,

Damir

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

John,

You are right in this context-no doubt.

What about one line export in csv?

Brg

Damir

Well, I guess there shouldn’t be a delimiter after a one line export, but there is. So that seems to be a bug.

John,

OK this is clear, but I asked about export of all records in one line (not in columns…this is the point.

Sorry for being misunderstood.

Brg,

Damir

Oh, I misunderstood, sorry.

No, we don’t have any feature to make all rows (even if there was only one column) export into a single row in the file.

There may be an Oracle function call to do what you want ….

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Monday, October 14, 2013 9:04 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] RE: Export grid to csv problem (bug!?)

RE: RE: Export grid to csv problem (bug!?)

Reply by John Dorlon

Oh, I misunderstood, sorry.

No, we don’t have any feature to make all columns (even if there was only one) export into a single row in the file.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.