dynamobi/dynamobi — Issue #155: [LDB-167] flatfile adapter text delimiter weirdness
Author: dynamobi-build
Created: 2011-12-30 02:17:18+00:00
State: open
Labels: Flatfile, LDB

[reporter="schoi", created="Wed, 12 Sep 2007 17:02:15 -0500 (GMT-05:00)"]
[migrated jira issue from LER-3974]

for numeric columns, flatfile adapter will complain about empty values being non-numeric if they're quoted.

that is, the empty sequence (field delimiter)(field delimiter), such as:

\t\t

...is considered numeric enough for flatfile wrapper not to complain.

but, with text delimiters, the likewise empty sequence (field delimiter)(text delimiter)(text delimiter)(field delimiter), such as:

\t""\t

...is not numeric and wrapper will choke.

On may think that "text delimiter" would imply a text value and thus the error being perfectly understandable, but since we do quote non-empty numeric values such as "4711", this is sort of inconsistent.