# Import Table Data locks up Toad under certain condition

**URL:** <https://forums.toadworld.com/t/import-table-data-locks-up-toad-under-certain-condition/39426>\
**Category:** Toad for Oracle - Beta\
**Created:** [May 4, 2017, 3:50pm UTC](https://forums.toadworld.com/t/import-table-data-locks-up-toad-under-certain-condition/39426 "2017-05-04T15:50:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![droeschley\_109](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@droeschley\_109](https://forums.toadworld.com/u/droeschley_109)\
**Post date:** [May 4, 2017, 3:50pm UTC](https://forums.toadworld.com/t/import-table-data-locks-up-toad-under-certain-condition/39426/1 "2017-05-04T15:50:34Z")

</div>

Importing a pipe-delimited text file with a line that contains a “Special” character (see last line below). The 3rd column would not get populated until I set the Text Qualifier option to “None” but that caused Toad to spin forever and have to be killed. Removing the line with the “special” character resolved this, of course, but it’d be nice to have Toad do something more elegant when it encounters this situation.

CREATE TABLE BD\_MDCOMP\_20170501  
(  
SYMBOL VARCHAR2(20 BYTE),  
BD\_MDCOMP\_UID RAW(12),  
TIMESTAMP\_STR VARCHAR2(40 BYTE),  
FILENAME VARCHAR2(50 BYTE),  
LINE\_NUM NUMBER(38)  
)

ULST|0D14DD7000004CA3F29E0859| 0 0 2017050220000|BBOD08E\_BIN\_20170502.log|18554777  
ULST|0D14DD7000004DA3F29E0859| 0 0 2017050220000|BBOD08E\_BIN\_20170502.log|18554778  
ULST|0D14DD7000004FA3F29E0859| 0 0 2017050220000|BBOD08E\_BIN\_20170502.log|18554779  
UMX|0D14DD7000000DA3F29E0859| 0 0 2017050220000|BBOD08E\_BIN\_20170502.log|18554782

---

<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:** [May 5, 2017, 6:02am UTC](https://forums.toadworld.com/t/import-table-data-locks-up-toad-under-certain-condition/39426/2 "2017-05-05T06:02:34Z")

</div>

Hi Dale,

I was unable to reproduce any problem at all importing this file. I tried with several combinations of settings for both text qualifier and trim spaces.

Can you copy/paste the action (or send screen shots of settings) and send them to me? [john.dorlon@quest.com](mailto:john.dorlon@quest.com)

Thanks

John

---

<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:** [May 5, 2017, 6:46am UTC](https://forums.toadworld.com/t/import-table-data-locks-up-toad-under-certain-condition/39426/3 "2017-05-05T06:46:14Z")

</div>

Maybe the special character didn’t paste into ToadWorld. I’m not seeing it.

---

<div class="post-metadata">

**Author:** ![droeschley\_109](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@droeschley\_109](https://forums.toadworld.com/u/droeschley_109)\
**Post date:** [May 5, 2017, 10:08am UTC](https://forums.toadworld.com/t/import-table-data-locks-up-toad-under-certain-condition/39426/4 "2017-05-05T10:08:42Z")

</div>

John, I sent you the data via email, so hopefully the special character came through. If not the value is a hex 1A and it was the only character on the last line. That character imported successfully when I had the Text Qualifier option set to the default of double-quote("), but then that caused import to ignore the 3rd column values (nothing imported into 3rd column, nothing displayed in Import Table Data windows.