Rules for importing CSV data files

When importing the CSV files, these rules must be applied to ensure the required data is imported correctly:

• If a value includes the selected column delimiter, the value must be enclosed in double quotes. For example, if the delimiter is |, a value of a|bc must be written as “a|bc”.
• If a value includes double quotes, an extra double quotes must be included before the existing double quotes. Additionally, the whole value must be enclosed in double quotes. For example, a value of a”bc must be written as “a””bc”.