Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ICsv interface 0x80070057 bug still remains
#1
Hello, Gintaras ~!!! it's been toooo long~!!

Most of files are OK, but some csv files couldn't get directly with csv.FromFile()


OS: Windows 8.1 x64

== Original code

ICsv Contents._create
str ST1

ST1.format("d:\somefile.csv")
Contents.Separator="|"
Contents.FromString(ST1);err


== modded by searching in forum threads -> get csv to file with getfile, delete '' with findreplace, and csv.FromString()

ICsv Contents._create
str strContents ST1

ST1.format("d:\somefile.csv")
strContents.getfile(ST1)
strContents.findreplace("''" "")
Contents.Separator="|"
Contents.FromString(strContents);err
#2
Probably cells contain quote characters not as enclosing characters, for example:
aaa"aaa"aaa| bbb
Such CSV is invalid.
QM3 will have an option to use some other enclosing character instead of ".
In QM2 your code is OK.
#3
OHHH~!!! QM3~!!! I MUST BE THE FIRST USER!!!! I'M EAGER TO USE IT !!!!!!


Forum Jump:


Users browsing this thread: 2 Guest(s)