# TOAD 14 Export Dataset is broken

**URL:** <https://forums.toadworld.com/t/toad-14-export-dataset-is-broken/51638>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [December 1, 2020, 7:09am UTC](https://forums.toadworld.com/t/toad-14-export-dataset-is-broken/51638 "2020-12-01T07:09:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![volker.ricke](https://avatars.discourse-cdn.com/v4/letter/v/b77776/32.png) [@volker.ricke](https://forums.toadworld.com/u/volker.ricke)\
**Post date:** [December 1, 2020, 7:09am UTC](https://forums.toadworld.com/t/toad-14-export-dataset-is-broken/51638/1 "2020-12-01T07:09:13Z")

</div>

I am having trouble using "Export dataset" feature in TOAD 14.0.75.662.  
If there are two null following null value columns in a row, TOAD 14 does not export the row with the correct number of delimiters.

Example:  
SELECT 1 as row\_number, 1 as col1, 'One' as col2, 1.1 as col3 from dual  
union  
SELECT 2 as row\_number, null as col1, '' as col2, 2.2 as col3 from dual  
union  
SELECT 3 as row\_number, 3 as col1, 'Three' as col2, null as col3 from dual  
union  
SELECT 4 as row\_number, 4 as col1, '' as col2, 4.4 as col3 from dual  
order by 1

TOAD 14 exports (using Pipe delimiter)

> "ROW\_NUMBER"|"COL1"|"COL2"|"COL3"  
> 1|1|"One"|1,1  
> 2||2,2  
> 3|3|"Three"  
> 4|4||4,4

So in row\_number 2 the value of COL3 is put into COL2.

TOAD 13 correctly exports this:

> "ROW\_NUMBER"|"COL1"|"COL2"|"COL3"  
> 1|1|"One"|1,1  
> 2|||2,2  
> 3|3|"Three"|  
> 4|4||4,4

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [December 1, 2020, 4:29pm UTC](https://forums.toadworld.com/t/toad-14-export-dataset-is-broken/51638/2 "2020-12-01T16:29:23Z")

</div>

Thanks. This got reported through support recently.

This only happens when:

- Format is "Delimited Text" option,
- "Scientific Notation" is unchecked
- "Include null text" is unchecked
- "Number Quoting" is set not set to one of the "including nulls" choices

You can change any of the above for a workaround.

We'll have it fixed soon in beta. Sorry about that.

---

<div class="post-metadata">

**Author:** ![volker.ricke](https://avatars.discourse-cdn.com/v4/letter/v/b77776/32.png) [@volker.ricke](https://forums.toadworld.com/u/volker.ricke)\
**Post date:** [December 2, 2020, 6:52am UTC](https://forums.toadworld.com/t/toad-14-export-dataset-is-broken/51638/3 "2020-12-02T06:52:11Z")

</div>

Hi John,  
thank you for sharing the information.  
I will continue using TOAD 13 for these exports until the availablility of the bug fix.

Best regards, Volker

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [December 7, 2020, 6:30pm UTC](https://forums.toadworld.com/t/toad-14-export-dataset-is-broken/51638/4 "2020-12-07T18:30:36Z")

</div>

Fixed in the current beta, which you can get here. [Toad for Oracle 14.1 Beta](https://forums.toadworld.com/t/toad-for-oracle-14-1-beta/41283)

A change log is in the comments section of that link.