ICsv interface

[Lucas]

How import a csv file like:


"33996344","33996351","GB","GBR","UNITED KINGDOM"
"50331648","69956103","US","USA","UNITED STATES"
"69956104","69956111","BM","BMU","BERMUDA"
"69956112","83886079","US","USA","UNITED STATES"

using ICsv interface?

[Gintaras]

Macro

Code:

Copy      Help

ICsv c=CreateCsv
c.Separator=","
c.FromFile(s)

[Lucas]

Error (RT) in Macro2: 0x80070057, El parámetro no es correcto.

this code works:

Macro

Code:

Copy      Help

str ss.getfile("$Desktop$\test.csv")
ICsv v=CreateCsv
v.Separator=","
str bb.getfile(ss)
bb.findreplace("''" "")
v.FromString(bb)

[Gintaras]

QM bug. Error if first character in file is ".

This code can be used:
Macro

Code:

Copy      Help

ICsv c=CreateCsv; c.Separator=","
str s.getfile(f); s-"[]"
c.FromString(s)
c.RemoveRow(0)

[Lucas]

Is this bug fixed in 2.3.0.6?

[Gintaras]

No, will be fixed in .7. It will be released to day.