Database Reference
In-Depth Information
Here is an example taken from the
Export
page:
CSV
This format is understood by a lot of programs, and you may find it useful for
exchanging data. Note that it is a data-only format—no SQL structure here.
The available options are:
•
Fields terminated by
: We put a comma here, which means that a comma will
be placed after each field.
Fields enclosed by
•
: We place an enclosing character here (like the quote) to
ensure that a field containing the terminating character (comma) is not taken
for two fields.
Fields escaped by
•
: If the export generator finds the
Fields enclosed by
character inside a field, the
Fields escaped by
character will be placed before
it in order to protect it. For example,
"John
\"The
Great\"
Smith"
.
Search WWH ::
Custom Search