Dec-11-2018, 06:35 AM
(This post was last modified: Dec-11-2018, 06:35 AM by Gribouillis.)
nnsatpute Wrote:I can't paste exact file.You can do this
with open(datafile) as csvfile: s = csvfile.read(4096) print(repr(s))Then paste the output in the forum.
nnsatpute Wrote:But when i am opening same file in Excel it is comma separatedIf the file is comma separated, there is a problem with
Number(10,2)
because the comma must not be interpreted as a separating comma. Normally csv files avoid this by quoting "Number(10,2)"
. You need to know which quoting strategy is used and declare this in the dialect.