Toad World® Forums

Unbalanced " in data causes decimeters to be ignored during data import in toad 13.1

I have noticed that having an unbalanced " in the data being imported from a text file causes the rest of the delimiters for the row to be ignored.

For example:

93491006000017, 2016-06-30, 990PF, 200926682, JOHN STOTTMAN, VP & TREAS, 1.00, 0
or
93491006000017, 2016-06-30, 990PF, 200926682, "JOHN STOTTMAN", VP & TREAS, 1.00, 0

will import just fine, but:

93491006000017, 2016-06-30, 990PF, 200926682, JOHN STOTTMAN", VP & TREAS, 1.00, 0

will result in JOHN STOTTMAN", VP & TREAS, 1.00, 0 being imported as one data entry instead of 4 separate ones.

The result is the same for all other delimiter types as well.

I guess the best thing Toad could have done in this case is give some kind of "quotation mismatch" error and not import the row. Is that what you are asking for? I don't think it's fair to expect Toad to just know to throw away that one double quote.