Use these settings when you specify a field separator and other settings:
|
Setting |
Effect |
|
No separation |
No separator character is used between fields within a record in the transfer file. The length of each field of data is fixed. |
|
Tab between fields |
Tabs are inserted between fields of data. |
|
Comma between fields |
Commas are inserted between fields of data. |
|
Other separator |
Type a different character that you want FORMS to insert. |
|
Quotation marks |
Quotation marks are inserted around alphanumeric values. Numeric fields will not have quotation marks. |
|
Compact |
Prevents field values from being padded to their maximum length with the pad character indicated in the Properties dialog. Note: Compact has no effect on a field if is specified in the field definition or if Pad always is selected in the Properties dialog for the field. If you are planning to transfer your data via a DLL or via VBA, do not specify a field separator and do not select Compact. |
The last field in a record is not followed by the separator character, because users usually prefer to end each record with a carriage return. The exception is when the transaction description contains #If statements. In this case the last field in the record can be followed by a separator character because, for example, the last transaction field is #EndIf.
If you select both Compact and Comma between fields in a start transaction description, one or more characters of output data is lost from the first form or set that is transferred.
If you plan to use SPSS statistics analysis program to examine data from the transaction, read more about this before choosing anything in the Transaction description options dialog.