Hi folks

I'm having a bit of a problem with APPEND FROM and was wondering if its my understanding or a problem with VFP...

I have a test text file with the following

1,2,3
1,,3

which I want to import into a cursor with fields a,b,c so I do

APPEND FROM test.txt DELIMITED WITH ,

The first line is fine but the second line imports as
a=1
b=3

whereas I would have thought (and want) :
a=1
b = blank
c = 3

Basically if there is no value for the field then the text file will just output a comma instead of value and comma.

Its fine if the data is "" delimited

Any ideas would be appreciated...