2. Function, Operation

2-50

When importing information using a CSV file, how should " (double‑quote) characters be written in an information field (column) if I want to include them?

In the CSV files imported by NetSkateKoban, when you want to include , (comma) in the information field, the specification requires that the string in that field be enclosed in " (double‑quote characters).

Therefore, if " (double‑quote characters) are written as part of the input data, it may be interpreted as the " that defines the field boundary, which can cause the row to fail to import correctly.

When writing " (double‑quote characters) as part of the information field, please write " twice like "".

Example 1: When writing the three strings '"aabb', 'ccdd"', and 'eeff' into three fields.

　　""aabb,ccdd"",eeff

Example 2: When writing the three strings '"' , 'a', and '""' into three fields.

　　"""",a,""""""

　　　⇒　The " (double‑quote characters) at both ends of the strings in the first and third fields are enclosing characters used to indicate the boundaries of each field.