Toad World® Forums

Import Table Data locks up Toad under certain condition

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

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

Thanks

John

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

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.