Download User Reference Guide - MSC Fileman 22.2 Documentation

Part 6: Moving Data
MSC Fileman 22.2 User Reference Guide
application and the importing application) must be able to recognize the
format.
Quoted Fields in Delimited Format
Now suppose in the previous example that instead of two separate fields
for LASTNAME and FIRSTNAME, there is only a single NAME field for
both. Suppose that incoming data you want to place in the single NAME
field comes in the form FMPATIENT,FOUR, but you still want to use
commas as your delimiter. You can use the "Fields Quoted" setting in the
Import form (or the Quote Non-Numeric Fields setting in a Foreign
Format) to ignore the delimiter if it is between quotes in the incoming data.
Thus, if you set "Fields Quoted" to YES in your import form, and you pass
in a record that looks like:
"FMPATIENT,FOUR",90 123rd St.,,,San Francisco,CA,94112
For quoted fields, like "FMPATIENT,FOUR", the Import Tool will ignore the
comma delimiter in-between the quotes and treat "FMPATIENT,FOUR" as a
single field value.
Fixed-Length Data Format
In fixed-length data format, a standard width is expected for each field in
the record. Suppose, for example, you have a record with LASTNAME =
"FMPATIENT", FIRSTNAME = "ONE", AGE = "36". 25 characters might be
set aside for LASTNAME, 20 characters for FIRSTNAME, and 3 characters
for AGE. The resulting record, exported in fixed-length format, would look
like:
FMPATIENT
ONE
36
Groups of records are exported line-by-line, one line after another. A file of
records in fixed-length format might look like:
January 2015
329