Forum Discussion

malj's avatar
malj
Contributor
10 years ago

Problem with DDT.CurrentDriver.Value(i)

I am having a problem reading values from a csv file using the code below. I have created a schema.ini file with contents below and it seems to be found and used. DDT.CurrentDriver.Value(i) returns null but DDT.CurrentDriver.ColumnName(i) gives me the column names as specified in the schema.ini file. Any ideas?  

 

[sequence.csv]

Format=Delimited(;)

DecimalSymbol=,

ColNameHeader=True

MaxScanRows=10

Col1=nejm Text Width 10

Col2=adress Text Width 30

Col3=whatever Text Width 10

 

 

DDT.CSVDriver("C:\Users\malj\AppData\Local\Temp\sequence.csv")

While Not DDT.CurrentDriver.EOF() 

  For i = 0 To DDT.CurrentDriver.ColumnCount - 1
    Log.Message DDT.CurrentDriver.ColumnName(i) & ": " & DDT.CurrentDriver.Value(i)
  Next

  DDT.CurrentDriver.Next()

WEnd