02-08-2012 07:46 PM
Hi, I am new to EG4.3 and can't seem to find out how to set the output options.
I am using the Export Wizard to export a csv file but I cannot find out where to change the options.
The output shows missing values as "." but I would rather it be blank in the csv file.
Is there a way to set up the option for missing=' ' or dDo I have to write code?
02-08-2012 09:14 PM
The only dbms option I'm aware of the write missing values as blanks is dbf (i.e., dbase). If you weren't using EG, I'd suggest recalling the code with function key F4 and just modifying the code.
I'm not sure if the code ends up in the log with EG but, if it does, you could copy and paste it, then modify it to account for this missing values.
Other than that, I'd go with Doc's recommendation.