I store survey-data in VFP for further transport to SPSS for analysis. There are some advantages by doing this, but I have one problem that VFP-support don't seem to cope with. I recive ASCII-files with data that I read in to the database with the command APPEND FROM...SDF to tell it is system data format. In the ASCII-files I hav ecoded material such as attitudes from 1-5 and 0 for a respondent who says "Don't know". I also have blanks when the respondent have given no answer. This is not the same as "Don't know" because this is to be handled as a missing value, a drop out. When I read the ASCI-file in to VFP and browse the data there is a distinction between 0 and blank, but both are treated as 0. Now (or even better when I run APPEND FROM) I want to turn the blanks in to .NULL. witch is what they are. I can't fin a way. Is there really no such way?
Thanks for any help
Per Strid