Creating Comma-Delimited File That Retains Trailing Space

MORE INFORMATION

The following code uses low-level file functions to read the CLIENTS.DBF sample database file and place the characters and trailing blanks of each field in a comma-delimited ASCII file named TEST.TXT:

   USE C:\Foxprow\Sample\Organize\dbfs\clients.dbf
   HFILE=FCREATE('c:\Test.txt')
   GO TOP
   SCAN
   =FPUTS(HFILE,Client_id+","+Company+","+Contact+","+Address+;
   ","+City+","+State+","+Zip+","+Areacode+","+Phone+","+Extension;
   +","+STR(startbal,8,2)+","+DTOC(Baldate)+Cuisine+","+STR(Type)+",";
   +Notes)
   ENDSCAN
   =FCLOSE(HFILE)
				

NOTE: By default, the FPUTS() function expects character type data in the fields. Therefore, in order to use numeric and date fields, add the STR() and DTOC() functions to convert the respective fields to character type data. Adding additional parameters to the STR() function preserves the decimal places in the numeric fields.